Advertisement
clickio

Disable ad units without monetization

Jun 29th, 2021
1,191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.10 KB | None | 0 0
  1. DROP TEMPORARY TABLE IF EXISTS adunits_to_disable;
  2. CREATE TEMPORARY TABLE adunits_to_disable
  3. SELECT DISTINCT sa.site_area_id, bsa.user_id, sa.`create_date`, bsa.adv_expense_gbp_30 FROM site_area sa
  4. JOIN bi.site_area bsa ON bsa.site_area_id = sa.site_area_id
  5. WHERE bsa.adv_expense_gbp_30 = 0
  6. AND sa.`create_date` < ( NOW() - INTERVAL 3 MONTH )
  7. AND bsa.user_id IN (
  8. 109931,
  9. 143727,
  10. 120761,
  11. 130221,
  12. 118339,
  13. 130905,
  14. 143174,
  15. 118799,
  16. 103491,
  17. 145613,
  18. 143885,
  19. 132502,
  20. 145397,
  21. 142171,
  22. 111441,
  23. 126356,
  24. 145417,
  25. 128837,
  26. 119997,
  27. 134210,
  28. 116214,
  29. 142788,
  30. 126239,
  31. 122345,
  32. 129927,
  33. 131337,
  34. 114289,
  35. 113821,
  36. 128603,
  37. 128317,
  38. 143924,
  39. 132396,
  40. 125676,
  41. 142210,
  42. 118982,
  43. 122065,
  44. 127672,
  45. 141408,
  46. 132210,
  47. 117170,
  48. 145591,
  49. 123677,
  50. 134435,
  51. 108350,
  52. 131176,
  53. 130273,
  54. 113512,
  55. 108589,
  56. 143263,
  57. 127942,
  58. 140542,
  59. 111040,
  60. 136691,
  61. 141406,
  62. 131388,
  63. 127308,
  64. 125922,
  65. 129416,
  66. 124567,
  67. 130955,
  68. 113159,
  69. 140209,
  70. 141407,
  71. 141405,
  72. 143153,
  73. 102556
  74. );
  75.  
  76. UPDATE site_area sa
  77. JOIN adunits_to_disable dsa ON sa.`site_area_id` = dsa.`site_area_id`
  78. SET sa.active = 0,
  79. sa.modify_date = NOW(),
  80. sa.deleted = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement