Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM `produzione_smp_old` WHERE 1
- INSERT INTO `produzione_smp_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`.`D3113__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`.`D3113__THS_T` IS NOT NULL OR (`e`.`D3113__THS_T` IS NULL AND `e`.`D3113__THS_T_flags` LIKE '%c%')
- OR ((`e`.`D3113__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`.`D3113__THS_T` IS NOT NULL OR (`y`.`D3113__THS_T` IS NULL AND `y`.`D3113__THS_T_flags` LIKE '%c%')
- OR ((`y`.`D3113__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`.`D3113__THS_T` IS NOT NULL OR (`q`.`D3113__THS_T` IS NULL AND `q`.`D3113__THS_T_flags` LIKE '%c%')
- OR ((`q`.`D3113__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`.`D3113__THS_T` IS NOT NULL OR (`y`.`D3113__THS_T` IS NULL AND `y`.`D3113__THS_T_flags` LIKE '%c%')
- OR ((`y`.`D3113__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`.`D3113__THS_T` IS NOT NULL OR (`w`.`D3113__THS_T` IS NULL AND `w`.`D3113__THS_T_flags` LIKE '%c%')
- OR ((`w`.`D3113__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`.`D3113__THS_T` IS NOT NULL OR (`y`.`D3113__THS_T` IS NULL AND `y`.`D3113__THS_T_flags` LIKE '%c%')
- OR ((`y`.`D3113__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`.`D3113__THS_T` IS NOT NULL OR (`w`.`D3113__THS_T` IS NULL AND `w`.`D3113__THS_T_flags` LIKE '%c%')
- OR ((`w`.`D3113__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`.`D3113__THS_T` IS NOT NULL OR (`b`.`D3113__THS_T` IS NULL AND `b`.`D3113__THS_T_flags` LIKE '%c%')
- OR ((`b`.`D3113__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_smp_old SET `country`='Olanda' WHERE `country`='Paesi Bassi'
- UPDATE produzione_smp_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 `D3113__THS_T`=1))
- RENAME TABLE produzione_smp to produzione_smp_tmp, produzione_smp_old to produzione_smp, produzione_smp_tmp to produzione_smp_old
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement