panchenko_33-37

"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`;"