Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "UPDATE site_area_design_24 AS site_area_design_24, (SELECT s.`site_area_id`
- FROM `site_area_design_24` s
- JOIN site_area a ON s.`site_area_id`=a.`site_area_id`
- JOIN bi.site_area b ON s.`site_area_id`=b.`site_area_id`
- WHERE s.site_area_id = 710501 AND dfp_special_sizes LIKE '%fluid%' AND dfp_adunit_params NOT LIKE '%fluid%' AND s.npm_size_id = 40 AND a.`deleted`=0 AND a.`active`=1) z,
- site_area AS site_area
- SET site_area_design_24.`dfp_adunit_params` = JSON_SET(dfp_adunit_params, '$.special_sizes', JSON_EXTRACT(site_area_design_24.`dfp_special_sizes`, '$.special_sizes'), '$.special_sizes_only', site_area_design_24.`dfp_special_sizes_only`), site_area.`modify_date`= NOW()
- WHERE site_area_design_24.`site_area_id` = z.`site_area_id` AND site_area.`site_area_id` = z.`site_area_id`;"
- ######################################
- "UPDATE site_area_design_24 AS site_area_design_24, (SELECT s.`site_area_id`
- FROM `site_area_design_24` s
- JOIN site_area a ON s.`site_area_id`=a.`site_area_id`
- JOIN bi.site_area b ON s.`site_area_id`=b.`site_area_id`
- WHERE s.site_area_id = 711880 AND dfp_special_sizes LIKE '%fluid%' AND dfp_adunit_params NOT LIKE '%fluid%' AND s.npm_size_id = 40 AND a.`deleted`=0 AND a.`active`=1) z,
- site_area AS site_area
- SET site_area_design_24.`dfp_adunit_params` = JSON_SET(dfp_adunit_params, '$.special_sizes', JSON_EXTRACT(site_area_design_24.`dfp_special_sizes`, '$.special_sizes'), '$.special_sizes_only', site_area_design_24.`dfp_special_sizes_only`), site_area.`modify_date`= NOW()
- WHERE site_area_design_24.`site_area_id` = z.`site_area_id` AND site_area.`site_area_id` = z.`site_area_id`;"
- ######################################
- "UPDATE site_area_design_24 AS site_area_design_24, (SELECT s.`site_area_id`
- FROM `site_area_design_24` s
- JOIN site_area a ON s.`site_area_id`=a.`site_area_id`
- JOIN bi.site_area b ON s.`site_area_id`=b.`site_area_id`
- WHERE s.site_area_id = 709639 AND dfp_special_sizes LIKE '%fluid%' AND dfp_adunit_params NOT LIKE '%fluid%' AND s.npm_size_id = 40 AND a.`deleted`=0 AND a.`active`=1) z,
- site_area AS site_area
- SET site_area_design_24.`dfp_adunit_params` = JSON_SET(dfp_adunit_params, '$.special_sizes', JSON_EXTRACT(site_area_design_24.`dfp_special_sizes`, '$.special_sizes'), '$.special_sizes_only', site_area_design_24.`dfp_special_sizes_only`), site_area.`modify_date`= NOW()
- WHERE site_area_design_24.`site_area_id` = z.`site_area_id` AND site_area.`site_area_id` = z.`site_area_id`;"
- ####################################
- "UPDATE site_area_design_24 AS site_area_design_24, (SELECT s.`site_area_id`
- FROM `site_area_design_24` s
- JOIN site_area a ON s.`site_area_id`=a.`site_area_id`
- JOIN bi.site_area b ON s.`site_area_id`=b.`site_area_id`
- WHERE s.site_area_id = 709647 AND dfp_special_sizes LIKE '%fluid%' AND dfp_adunit_params NOT LIKE '%fluid%' AND s.npm_size_id = 40 AND a.`deleted`=0 AND a.`active`=1) z,
- site_area AS site_area
- SET site_area_design_24.`dfp_adunit_params` = JSON_SET(dfp_adunit_params, '$.special_sizes', JSON_EXTRACT(site_area_design_24.`dfp_special_sizes`, '$.special_sizes'), '$.special_sizes_only', site_area_design_24.`dfp_special_sizes_only`), site_area.`modify_date`= NOW()
- WHERE site_area_design_24.`site_area_id` = z.`site_area_id` AND site_area.`site_area_id` = z.`site_area_id`;"
- ##################################
- "UPDATE site_area_design_24 AS site_area_design_24, (SELECT s.`site_area_id`
- FROM `site_area_design_24` s
- JOIN site_area a ON s.`site_area_id`=a.`site_area_id`
- JOIN bi.site_area b ON s.`site_area_id`=b.`site_area_id`
- WHERE s.site_area_id = 712079 AND dfp_special_sizes LIKE '%fluid%' AND dfp_adunit_params NOT LIKE '%fluid%' AND s.npm_size_id = 40 AND a.`deleted`=0 AND a.`active`=1) z,
- site_area AS site_area
- SET site_area_design_24.`dfp_adunit_params` = JSON_SET(dfp_adunit_params, '$.special_sizes', JSON_EXTRACT(site_area_design_24.`dfp_special_sizes`, '$.special_sizes'), '$.special_sizes_only', site_area_design_24.`dfp_special_sizes_only`), site_area.`modify_date`= NOW()
- WHERE site_area_design_24.`site_area_id` = z.`site_area_id` AND site_area.`site_area_id` = z.`site_area_id`;"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement