DROP TEMPORARY TABLE IF EXISTS adunits_to_disable;
CREATE TEMPORARY TABLE adunits_to_disable
SELECT DISTINCT sa.site_area_id, bsa.user_id, sa.`create_date`, bsa.adv_expense_gbp_30 FROM site_area sa
JOIN bi.site_area bsa ON bsa.site_area_id = sa.site_area_id
WHERE bsa.adv_expense_gbp_30 = 0
AND sa.`create_date` < ( NOW() - INTERVAL 3 MONTH )
AND bsa.user_id IN (
109931,
143727,
120761,
130221,
118339,
130905,
143174,
118799,
103491,
145613,
143885,
132502,
145397,
142171,
111441,
126356,
145417,
128837,
119997,
134210,
116214,
142788,
126239,
122345,
129927,
131337,
114289,
113821,
128603,
128317,
143924,
132396,
125676,
142210,
118982,
122065,
127672,
141408,
132210,
117170,
145591,
123677,
134435,
108350,
131176,
130273,
113512,
108589,
143263,
127942,
140542,
111040,
136691,
141406,
131388,
127308,
125922,
129416,
124567,
130955,
113159,
140209,
141407,
141405,
143153,
102556
);
UPDATE site_area sa
JOIN adunits_to_disable dsa ON sa.`site_area_id` = dsa.`site_area_id`
SET sa.active = 0,
sa.modify_date = NOW(),
sa.deleted = 1;
Comments
0 B
|0 👍
/0 👎
0 B
|👍
/👎