Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement