API tools faq
paste
Guest User

Untitled

a guest
Oct 19th, 2017
63
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.96 KB | None | 0 0
raw download clone embed print report
  1. SELECT id_user,sumcount,sumrev,sumadrev FROM
  2. ( SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_01 GROUP BY id_user
  3. UNION
  4. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_02 GROUP BY id_user
  5. UNION
  6. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_03 GROUP BY id_user
  7. UNION
  8. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_04 GROUP BY id_user
  9. UNION
  10. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_05 GROUP BY id_user
  11. UNION
  12. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_06 GROUP BY id_user
  13. UNION
  14. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_07 GROUP BY id_user
  15. UNION
  16. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_08 GROUP BY id_user
  17. UNION
  18. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_09 GROUP BY id_user
  19. UNION
  20. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_10 GROUP BY id_user
  21. UNION
  22. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_11 GROUP BY id_user
  23. UNION
  24. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_12 GROUP BY id_user
  25. UNION
  26. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_13 GROUP BY id_user
  27. UNION
  28. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_14 GROUP BY id_user
  29. UNION
  30. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_15 GROUP BY id_user
  31. UNION
  32. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_16 GROUP BY id_user
  33. UNION
  34. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_17 GROUP BY id_user
  35. UNION
  36. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_18 GROUP BY id_user
  37. UNION
  38. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_19 GROUP BY id_user
  39. UNION
  40. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_20 GROUP BY id_user
  41. UNION
  42. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_21 GROUP BY id_user
  43. UNION
  44. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_22 GROUP BY id_user
  45. UNION
  46. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_23 GROUP BY id_user
  47. UNION
  48. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_24 GROUP BY id_user
  49. UNION
  50. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_25 GROUP BY id_user
  51. UNION
  52. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_26 GROUP BY id_user
  53. UNION
  54. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_27 GROUP BY id_user
  55. UNION
  56. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_28 GROUP BY id_user
  57. UNION
  58. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_29 GROUP BY id_user
  59. UNION
  60. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_30 GROUP BY id_user
  61. UNION
  62. SELECT id_user,count(id) as sumcount,sum(revenue) as sumrev,sum(ad_revenue) as sumadrev FROM adfocus_ads_date_db_201108.ads_served_31 GROUP BY id_user
  63. ) combined
  64. GROUP BY id_user
  65. ORDER BY sumcount DESC
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!