Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
1,579
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.35 KB | None | 0 0
  1. DROP TABLE IF EXISTS dev_bsee.launcher_users;
  2. CREATE TABLE dev_bsee.launcher_users (
  3. user_id int, is_teespring_user int
  4. )
  5. DISTKEY(user_id)
  6. SORTKEY(user_id);
  7. INSERT INTO dev_bsee.launcher_users (
  8. select user_id, case when email ilike '%teespring.com' then 1 else 0 end as is_teespring_user
  9. from rollups.seller_facts sf
  10. where lower(sf.email) in (
  11. 'parker@parkerhiggins.net',
  12. 'rtb@techdirt.com',
  13. 'chuckthetingler@gmail.com',
  14. 'mrnappyboy92@gmail.com',
  15. 'drunkenpeasant@outlook.com',
  16. 'alice.goldfuss@gmail.com',
  17. 'krismcasey@gmail.com',
  18. 'godlessmaniacs@gmail.com',
  19. 'info@stop-homophobia.com',
  20. 'bijuumikebusiness@gmail.com',
  21. 'military-life@outlook.com',
  22. 'iamalexkidd@gmail.com',
  23. 'dowellcannon@gmail.com',
  24. 'randomassaultpodcast@gmail.com',
  25. 'sally@fangirlshirts.com',
  26. 'melaninmindsmeet@gmail.com',
  27. 'snowcatxx87@live.com',
  28. 'wagonpodcast@gmail.com',
  29. 'thesouthernsassenachs@gmail.com',
  30. 'natethomas@xbmc.org',
  31. 'authorhazeljames@gmail.com',
  32. 'briankennedy1@gmail.com',
  33. 'juicefromthebox@gmail.com',
  34. 'darius.kazemi@gmail.com',
  35. 'evelynfromtheinternets@gmail.com',
  36. 'redsweaterpro@gmail.com',
  37. 'chadeboi20@gmail.com',
  38. 'ralphtherex6@gmail.com',
  39. 'paul@buckleyphotos.com',
  40. 'chris@trulytulsa.com',
  41. 'philip.howell@gmail.com',
  42. 'juancarlosnyc27@gmail.com',
  43. 'teespring@goio.com',
  44. 'jeffshap@gmail.com',
  45. 'jonathan@betterworldgear.com',
  46. 'manateemarketinginc@gmail.com',
  47. 'jenisefrohlinger@gmail.com',
  48. 'nick@irrationallypassionate.com',
  49. 'info@bigrigapparel.com',
  50. 'chris@trulytulsa.com',
  51. 'slinger@arrowslinger.com',
  52. 'sellshirtsusa@gmail.com',
  53. 'teamihsdigital@gmail.com',
  54. 'cps452@gmail.com',
  55. 'nfkmobile@gmail.com',
  56. 'rytismarketing@gmail.com',
  57. 'things@inkleap.com',
  58. 'hello@andymccune.com',
  59. 'miklanderson2@gmail.com',
  60. 'partners@gizzifter.com',
  61. 'allarddavid@hotmail.com',
  62. 'mad4shirts@yahoo.com',
  63. 'darrin.tarpley@gmail.com',
  64. 'kevdomains@gmail.com',
  65. 'ronniemckenziebiz@gmail.com',
  66. 'vietboihao@gmail.com',
  67. 'things@inkleap.com',
  68. 'singh4.manindra@yahoo.com',
  69. 'paula.steen6@gmail.com',
  70. 'jacksboston@gmail.com',
  71. 'admin@webinarwheel.com',
  72. 'scaleswiftmarketing@gmail.com',
  73. 'shloka.raaj@gmail.com',
  74. 'sales@snazzyshirts.net',
  75. 'ronan@quarmby.co.za',
  76. 'alisonscottcreative@gmail.com',
  77. 'panupong_nook@hotmail.com',
  78. 'tien.nguyen.ngoc88@gmail.com ',
  79. 'vuminhtien0909@gmail.com ',
  80. 'mojowbm@gmail.com',
  81. 'daproofni@gmail.com',
  82. 'jonawetter@gmail.com',
  83. 'ngoctan89.lhp@gmail.com',
  84. 'hai.hd90@gmail.com',
  85. 'fery@finder.co.id',
  86. 'youngbobusiness@gmail.com',
  87. 'opposite.ex@gmail.com',
  88. 'crsb13@gmail.com',
  89. 'drew@toothpastefordinner.com',
  90. 'mattrud@gmail.com',
  91. 'william@legate.me',
  92. 'zachary.hamman2@gmail.com',
  93. 'blazelifehammer@gmail.com',
  94. 'atheismisunstoppable@gmail.com',
  95. 'grandwebdesignsuk@gmail.com',
  96. 'chris.meinck@mobilenations.com',
  97. 'creativebeau@gmail.com',
  98. 'lapfox@gmail.com',
  99. 'hello@mushbuh.com',
  100. 'jessicanigri@hotmail.com',
  101. 'animeamericapodcast@gmail.com',
  102. 'rmmbastos@gmail.com',
  103. 'mrsteakart@gmail.com',
  104. 'hello@scottwebb.me',
  105. 'mdlabick@gmail.com',
  106. 'aztrosist@gmail.com',
  107. 'ushiumagashi@gmail.com',
  108. 'kihuart@gmail.com',
  109. 'ashschmitt@gmail.com',
  110. 'hautebebe@yahoo.com',
  111. 'linh.tuan070987@gmail.com',
  112. 'despothes@gmail.com',
  113. 'dru.ubben@sbcglobal.net',
  114. 'lindi@olypen.com ',
  115. 'proud876@gmail.com',
  116. 'tiffanator606@gmail.com',
  117. 'diggerdesigns@gmail.com',
  118. 'suhail.mahadevan.biz@gmail.com',
  119. 'bennyhsu@gmail.com',
  120. 'flowergirl1078@gmail.com',
  121. 'fxdaytrader69@gmail.com ',
  122. 'ts@clientmaxmarketing.com',
  123. 'joel5wounds@gmail.com',
  124. 'nfkmobile@gmail.com '
  125. ) or sf.email ilike '%teespring.com'
  126. group by 1,2
  127. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement