DELETE FROM `produzione_butter_old` WHERE 1

INSERT INTO `produzione_butter_old` SELECT '', str_to_date(last_day(concat(`b`.`anno`,'-',`b`.`mese`,'-28')),'%Y-%m-%d') AS `year`,

  (SELECT `a`.`name_it`
   FROM `clal2_it`.`trade_country` `a`
   WHERE (`a`.`code` = `b`.`country`)) AS `country`,

  (SELECT `c`.`name_en`
   FROM `clal2_it`.`trade_country` `c`
   WHERE (`c`.`code` = `b`.`country`)) AS `country_en`,
       `b`.`D6000__THS_T`*1000 AS `val`,

  (SELECT `t`.`UE15`
   FROM `clal2_it`.`trade_country` `t`
   WHERE (`t`.`code` = `b`.`country`)) AS `ue15`,

  (SELECT COUNT(0)
   FROM `clal2_it`.`eu_production_data` `d`
   WHERE ((`d`.`id` = `b`.`id`)
          AND (`d`.`source` <> 'Eurostat'))) AS `manuale`,
       `b`.`source` AS `fonte`, NOW()
FROM `clal2_it`.`eu_production_data` `b`
WHERE ((`b`.`source` =
          (SELECT `e`.`source`
           FROM `clal2_it`.`eu_production_data` `e`
           WHERE ((`e`.`anno` = `b`.`anno`)
                  AND (`e`.`mese` = `b`.`mese`)
                  AND (`e`.`country` = `b`.`country`)
                  AND `e`.`source` IN ('Stimato CLAL','Eurostat')
              AND ((`e`.`D6000__THS_T` IS NOT NULL OR (`e`.`D6000__THS_T` IS NULL AND `e`.`D6000__THS_T_flags` LIKE '%c%')
        OR ((`e`.`D6000__THS_T` IS NULL AND (`e`.`D7121__THS_T` IS NOT NULL OR (`e`.`D7121__THS_T` IS NULL AND `e`.`D7121__THS_T_flags` LIKE '%c%'))) AND `e`.`source`='Eurostat'))))
           ORDER BY FIELD(`e`.`source`,'Stimato CLAL','Eurostat')
           LIMIT 1))
       AND ((`b`.`anno` <
               (SELECT MIN(`x`.`anno`)
                FROM `clal2_it`.`eu_production_data` `x`
                WHERE ((`x`.`id` =
                          (SELECT `y`.`id`
                           FROM `clal2_it`.`eu_production_data` `y`
                           WHERE ((`y`.`D6000__THS_T` IS NOT NULL OR (`y`.`D6000__THS_T` IS NULL AND `y`.`D6000__THS_T_flags` LIKE '%c%')
        OR ((`y`.`D6000__THS_T` IS NULL AND (`y`.`D7121__THS_T` IS NOT NULL OR (`y`.`D7121__THS_T` IS NULL AND `y`.`D7121__THS_T_flags` LIKE '%c%')))))
                                  AND (`y`.`anno` >= (
                                                        (SELECT MAX(`clal2_it`.`eu_production_data`.`anno`)
                                                         FROM `clal2_it`.`eu_production_data`
                                                         WHERE 1) - 1))
                                  AND (y.`source` = (SELECT `q`.`source`
           FROM `clal2_it`.`eu_production_data` `q`
           WHERE ((`q`.`anno` = `y`.`anno`)
                  AND (`q`.`mese` = `y`.`mese`)
                  AND (`q`.`country` = `y`.`country`)
                  AND `q`.`source` IN ('Stimato CLAL','Eurostat')
              AND (`q`.`D6000__THS_T` IS NOT NULL OR (`q`.`D6000__THS_T` IS NULL AND `q`.`D6000__THS_T_flags` LIKE '%c%')
        OR ((`q`.`D6000__THS_T` IS NULL AND (`q`.`D7121__THS_T` IS NOT NULL OR (`q`.`D7121__THS_T` IS NULL AND `q`.`D7121__THS_T_flags` LIKE '%c%'))))))
           ORDER BY FIELD(`q`.`source`,'Stimato CLAL','Eurostat')
           LIMIT 1))
                                  AND (`y`.`country` = `x`.`country`))
                           ORDER BY `y`.`anno` DESC,`y`.`mese` DESC
                           LIMIT 1))
                       AND `x`.`country` IN
                         (SELECT `clal2_it`.`trade_country`.`code`
                          FROM `clal2_it`.`trade_country`
                          WHERE (`clal2_it`.`trade_country`.`region_id` = '1')))))
            OR ((`b`.`anno` =
                   (SELECT MIN(`x`.`anno`)
                    FROM `clal2_it`.`eu_production_data` `x`
                    WHERE ((`x`.`id` =
                              (SELECT `y`.`id`
                               FROM `clal2_it`.`eu_production_data` `y`
                               WHERE ((`y`.`D6000__THS_T` IS NOT NULL OR (`y`.`D6000__THS_T` IS NULL AND `y`.`D6000__THS_T_flags` LIKE '%c%')
        OR ((`y`.`D6000__THS_T` IS NULL AND (`y`.`D7121__THS_T` IS NOT NULL OR (`y`.`D7121__THS_T` IS NULL AND `y`.`D7121__THS_T_flags` LIKE '%c%')))))
                                      AND (`y`.`anno` >= (
                                                            (SELECT MAX(`clal2_it`.`eu_production_data`.`anno`)
                                                             FROM `clal2_it`.`eu_production_data`
                                                             WHERE 1) - 1))
                                      AND (y.`source` = (SELECT `w`.`source`
           FROM `clal2_it`.`eu_production_data` `w`
           WHERE ((`w`.`anno` = `y`.`anno`)
                  AND (`w`.`mese` = `y`.`mese`)
                  AND (`w`.`country` = `y`.`country`)
                  AND `w`.`source` IN ('Stimato CLAL','Eurostat')
              AND (`w`.`D6000__THS_T` IS NOT NULL OR (`w`.`D6000__THS_T` IS NULL AND `w`.`D6000__THS_T_flags` LIKE '%c%')
        OR ((`w`.`D6000__THS_T` IS NULL AND (`w`.`D7121__THS_T` IS NOT NULL OR (`w`.`D7121__THS_T` IS NULL AND `w`.`D7121__THS_T_flags` LIKE '%c%'))))))
           ORDER BY FIELD(`w`.`source`,'Stimato CLAL','Eurostat')
           LIMIT 1))
                                      AND (`y`.`country` = `x`.`country`))
                               ORDER BY `y`.`anno` DESC,`y`.`mese` DESC
                               LIMIT 1))
                           AND `x`.`country` IN
                             (SELECT `clal2_it`.`trade_country`.`code`
                              FROM `clal2_it`.`trade_country`
                              WHERE (`clal2_it`.`trade_country`.`region_id` = '1')))))
                AND (`b`.`mese` <=
                       (SELECT `x`.`mese`*1
                        FROM `clal2_it`.`eu_production_data` `x`
                        WHERE ((`x`.`id` =
                                    (SELECT `y`.`id`
                                    FROM `clal2_it`.`eu_production_data` `y`
                                    WHERE (((`y`.`D6000__THS_T` IS NOT NULL OR (`y`.`D6000__THS_T` IS NULL AND `y`.`D6000__THS_T_flags` LIKE '%c%')
        OR ((`y`.`D6000__THS_T` IS NULL AND (`y`.`D7121__THS_T` IS NOT NULL OR (`y`.`D7121__THS_T` IS NULL AND `y`.`D7121__THS_T_flags` LIKE '%c%'))))))
                                            AND (`y`.`anno` >= (
                                                                (SELECT MAX(`clal2_it`.`eu_production_data`.`anno`)
                                                                FROM `clal2_it`.`eu_production_data`
                                                                WHERE 1) - 1))
                                            AND (y.`source` = (SELECT `w`.`source`
           FROM `clal2_it`.`eu_production_data` `w`
           WHERE ((`w`.`anno` = `y`.`anno`)
                  AND (`w`.`mese` = `y`.`mese`)
                  AND (`w`.`country` = `y`.`country`)
                  AND `w`.`source` IN ('Stimato CLAL','Eurostat')
              AND (`w`.`D6000__THS_T` IS NOT NULL OR (`w`.`D6000__THS_T` IS NULL AND `w`.`D6000__THS_T_flags` LIKE '%c%')
        OR ((`w`.`D6000__THS_T` IS NULL AND (`w`.`D7121__THS_T` IS NOT NULL OR (`w`.`D7121__THS_T` IS NULL AND `w`.`D7121__THS_T_flags` LIKE '%c%'))))))
           ORDER BY FIELD(`w`.`source`,'Stimato CLAL','Eurostat')
           LIMIT 1))
                                            AND (`y`.`country` = `x`.`country`))
                                    ORDER BY `y`.`anno` DESC,`y`.`mese` DESC
                                    LIMIT 1))
                                    AND `x`.`country` IN
                                    (SELECT `clal2_it`.`trade_country`.`code`
                                    FROM `clal2_it`.`trade_country`
                                    WHERE (`clal2_it`.`trade_country`.`region_id` = '1'))) ORDER BY `x`.`mese` ASC LIMIT 1))))
        AND `b`.`country` IN
            (SELECT `clal2_it`.`trade_country`.`code`
             FROM `clal2_it`.`trade_country`
             WHERE (`clal2_it`.`trade_country`.`region_id` = 1))
        AND (`b`.`D6000__THS_T` IS NOT NULL OR (`b`.`D6000__THS_T` IS NULL AND `b`.`D6000__THS_T_flags` LIKE '%c%')
        OR ((`b`.`D6000__THS_T` IS NULL AND (`b`.`D7121__THS_T` IS NOT NULL OR (`b`.`D7121__THS_T` IS NULL AND `b`.`D7121__THS_T_flags` LIKE '%c%'))))))
        ORDER BY `year` DESC

UPDATE produzione_butter_old SET `country`='Olanda' WHERE `country`='Paesi Bassi'

UPDATE produzione_butter_old SET `val`=NULL WHERE `country` IN (SELECT `name_it` FROM `trade_country` WHERE `code` IN (SELECT `iso` FROM eu_production_not_visible_countries WHERE `D6000__THS_T`=1))

RENAME TABLE produzione_butter to produzione_butter_tmp, produzione_butter_old to produzione_butter, produzione_butter_tmp to produzione_butter_old