Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS dev_bsee.launcher_users;
- CREATE TABLE dev_bsee.launcher_users (
- user_id int, is_teespring_user int
- )
- DISTKEY(user_id)
- SORTKEY(user_id);
- INSERT INTO dev_bsee.launcher_users (
- select user_id, case when email ilike '%teespring.com' then 1 else 0 end as is_teespring_user
- from rollups.seller_facts sf
- where lower(sf.email) in (
- 'parker@parkerhiggins.net',
- 'rtb@techdirt.com',
- 'chuckthetingler@gmail.com',
- 'mrnappyboy92@gmail.com',
- 'drunkenpeasant@outlook.com',
- 'alice.goldfuss@gmail.com',
- 'krismcasey@gmail.com',
- 'godlessmaniacs@gmail.com',
- 'info@stop-homophobia.com',
- 'bijuumikebusiness@gmail.com',
- 'military-life@outlook.com',
- 'iamalexkidd@gmail.com',
- 'dowellcannon@gmail.com',
- 'randomassaultpodcast@gmail.com',
- 'sally@fangirlshirts.com',
- 'melaninmindsmeet@gmail.com',
- 'snowcatxx87@live.com',
- 'wagonpodcast@gmail.com',
- 'thesouthernsassenachs@gmail.com',
- 'natethomas@xbmc.org',
- 'authorhazeljames@gmail.com',
- 'briankennedy1@gmail.com',
- 'juicefromthebox@gmail.com',
- 'darius.kazemi@gmail.com',
- 'evelynfromtheinternets@gmail.com',
- 'redsweaterpro@gmail.com',
- 'chadeboi20@gmail.com',
- 'ralphtherex6@gmail.com',
- 'paul@buckleyphotos.com',
- 'chris@trulytulsa.com',
- 'philip.howell@gmail.com',
- 'juancarlosnyc27@gmail.com',
- 'teespring@goio.com',
- 'jeffshap@gmail.com',
- 'jonathan@betterworldgear.com',
- 'manateemarketinginc@gmail.com',
- 'jenisefrohlinger@gmail.com',
- 'nick@irrationallypassionate.com',
- 'info@bigrigapparel.com',
- 'chris@trulytulsa.com',
- 'slinger@arrowslinger.com',
- 'sellshirtsusa@gmail.com',
- 'teamihsdigital@gmail.com',
- 'cps452@gmail.com',
- 'nfkmobile@gmail.com',
- 'rytismarketing@gmail.com',
- 'things@inkleap.com',
- 'hello@andymccune.com',
- 'miklanderson2@gmail.com',
- 'partners@gizzifter.com',
- 'allarddavid@hotmail.com',
- 'mad4shirts@yahoo.com',
- 'darrin.tarpley@gmail.com',
- 'kevdomains@gmail.com',
- 'ronniemckenziebiz@gmail.com',
- 'vietboihao@gmail.com',
- 'things@inkleap.com',
- 'singh4.manindra@yahoo.com',
- 'paula.steen6@gmail.com',
- 'jacksboston@gmail.com',
- 'admin@webinarwheel.com',
- 'scaleswiftmarketing@gmail.com',
- 'shloka.raaj@gmail.com',
- 'sales@snazzyshirts.net',
- 'ronan@quarmby.co.za',
- 'alisonscottcreative@gmail.com',
- 'panupong_nook@hotmail.com',
- 'tien.nguyen.ngoc88@gmail.com ',
- 'vuminhtien0909@gmail.com ',
- 'mojowbm@gmail.com',
- 'daproofni@gmail.com',
- 'jonawetter@gmail.com',
- 'ngoctan89.lhp@gmail.com',
- 'hai.hd90@gmail.com',
- 'fery@finder.co.id',
- 'youngbobusiness@gmail.com',
- 'opposite.ex@gmail.com',
- 'crsb13@gmail.com',
- 'drew@toothpastefordinner.com',
- 'mattrud@gmail.com',
- 'william@legate.me',
- 'zachary.hamman2@gmail.com',
- 'blazelifehammer@gmail.com',
- 'atheismisunstoppable@gmail.com',
- 'grandwebdesignsuk@gmail.com',
- 'chris.meinck@mobilenations.com',
- 'creativebeau@gmail.com',
- 'lapfox@gmail.com',
- 'hello@mushbuh.com',
- 'jessicanigri@hotmail.com',
- 'animeamericapodcast@gmail.com',
- 'rmmbastos@gmail.com',
- 'mrsteakart@gmail.com',
- 'hello@scottwebb.me',
- 'mdlabick@gmail.com',
- 'aztrosist@gmail.com',
- 'ushiumagashi@gmail.com',
- 'kihuart@gmail.com',
- 'ashschmitt@gmail.com',
- 'hautebebe@yahoo.com',
- 'linh.tuan070987@gmail.com',
- 'despothes@gmail.com',
- 'dru.ubben@sbcglobal.net',
- 'lindi@olypen.com ',
- 'proud876@gmail.com',
- 'tiffanator606@gmail.com',
- 'diggerdesigns@gmail.com',
- 'suhail.mahadevan.biz@gmail.com',
- 'bennyhsu@gmail.com',
- 'flowergirl1078@gmail.com',
- 'fxdaytrader69@gmail.com ',
- 'ts@clientmaxmarketing.com',
- 'joel5wounds@gmail.com',
- 'nfkmobile@gmail.com '
- ) or sf.email ilike '%teespring.com'
- group by 1,2
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement