[MO] thuong-vo

SELECT
SUM(conversion_publisher_payout) as payout,
count(*) as total
FROM ecom_conversions/conversion
WHERE
conversion_status_code = 1 AND
invoice_status_code = 1 AND
publisher_id in ('01664087560','711a13634518','accazure','activelove1993','adilasheradam','aedsasde1107','aff_zxcvbnm','akainu610','allintheone','alpenliebe','ammn229','android3d','anduy24','anh15','anh7','anhdungk4m','anhlarua','anhluc362','anhseo','anhtran','anhtuanmoongroup','anhungbmt','annyphan','apt1407','atkun01','awesome68','baby6789a1','babysnake18','baccong123','badboyhp199x','baduy88','balinh1006','bamboo2302','bamboo232','bangnguyen2013','baonguyengja','baosunday','baoth89','beckham','benhhocgioi','bestoffer','bgkiss','bibochannel','bichnganpy','bido2016','binhbicpabon1','binhphan112','binhreseo','binhtran91','blackdragon','bo0pxinh','boomandoo','bowromj','boygocda1','bqqviet1409','broken247','buihuuloc99','buiquocviet1409','buisonkt','caigivay','cangtom69','ccuonglexsus123','chudongtu191','chuyen123','ckiuzk059','clickbank247','cloudandwind','coffee','coipro','concolua','congtien286','cquangpham','cuongminhbk','cuongstar','cuongve2702','cuongxinnguyen','d4trung','dachm','dainhan','dan86','danghuypro997','dangngocha','dangnhatminh','dangthientu','danielvmc','daotandung91','datnd1987','davidtrong','ddan160787','dduongtpm4','delux1550','denkepban','dgon','dienle','dinhdang','dinhdungqdqd','dinhnhan87','dinhquocdat','dinhtrieu_12','dinhtt','doanhbi1995','doanphucbaotri2016','dochinh','docongphong','dokhacnin','dongducchung1994','dongnguyen94','donhatan8552','dorabe','dothanhhung','dotronghoa','dreamitvn','dreamy1995','duc9901','duchaudh','duchugo93','duchuy123','duckhanh','dungbosua','dungcoint','dungthuylls1','dungvg91','dungvl','duongdinhhuy','duongle89','duonglovely210','duongphi2310','duongxuantien','duy1995','duythe','ebgmedia','elgato7749','extrabonus','family0983216054','floweriron','flyupit','friendship293a','giangthanhkha','giatruyen','giayyumi0205','gingkira','h7t23e','hacuongns','haduylinhadv','haicomu','haidonginfo','haiho','hainam198','hainguyenitmta','haionlinemarketing','hakhuong','hangnguyentt','hanpham208','hathanhtung11','hathien0195','hellkaiser','hienmeo93','hiepnt89','hieumt','hieunguyen87','hieunt','hihihidlt','hk240292','hkhoemanh','hoamoclan1104','hoangdatst','hoanghai121992','hoangheodn1996','hoangminhson','hoangnghia0292','hoangnghiacp08','hoangnh','hoangocphuong91','hoangtrismpk','hoangtuanth7','hoangvannam','hoathehiep','hoduchoang','hoispm','honguyenhoang190693','hpviking','htsonca2702','huanvip73','hungbavuong','hungcuong411','hungdam_tn88','hungkhtn76657','hunglam','hunglam7891','hungn','huongveso78783','huuhuyphan2504','huuphucmaster','huyhxv','huynhnhu','huynhtranhcm','huytruongblog','hyipon','ignite','imath6868','itgroupcc','ithunter','jika9x','jimmypham','jimykotinhyeu','jlavnv','jonhnyluxus','july','jungdua_4802','junlucky','junnamduong','justice2075','kai1412','kaito2311','kakaxth','kali00089','katherinelien','kendyquyet','kenhtubevetinh','kennguyenandroid','kentashino','kevchou','kgtvhb','khanhhmc','khoaanh15111997','khogamevip247','khoilr','khuyenmaigiamgia','kiemtien_hn9x','kiemtienonline2016','kienkaka1408','kimcuccaokeu','kinakava','kinhtri','koalakia','konchuothoj','kt01','kubeoday','kupy006','kuthuy0502','kuviet146','kyojiduc64','kyonguyen','kythuatlhc','lackyb0y2016','lamgiadat2231','lamphongvy','lamthaofpt','lan1994','langson','ledemkhoc','leduyet2110','leduyhcm','lehaibac84','lehoan1192','lekhoi456','lelanh34','leminhtriqs1996','lenanghai','lesonnghiatv','lethai2597','lethanh9192','lethanhday','lethanhtien','levannhan','levu','levu1988','liendk2008','lkc2211','lleonicky','locloc1093','longhaiit1','longluu','longml','lovelyqueen109','luchien123456','luckyboytn2015','luongveha','luthekhanh','luxury6226','luyenvan70','magnetnghia','maiduy','maimiong','maithanhthuy','manhcuongpassion','manhmmxx','manhtuan25','martin1603','mary1808','masoffer','mastertips','member','milkiway14st','million98','mimilee','minh14101995','minhcanhtrinh','minhdien98','minhlee','minhphucapl','minhtan1980','minhvu001','minlove','mitalife','moli1411','money24','moonkids2t','mrbui56','mrhuynh87','mrquang','mrtinkcf','mrtuvietnam','muctieu500','mvtu','n2dxxx','namhoang','namnguyen79','namtuocbt879','navyseal','nc91','ncongnguyen2897','netvang123','newking79','newsaga1991','ngau','nghiemdoan','nghiepdpc','ngocbaolinh','ngochan0910','ngoclinh22100','ngocluctn','ngocson','ngoctuan01','ngodanh1303','ngohaian','ngolongqui','ngotranh','ngotrongkhoa','ngtruong227','ngtruong94bp','nguyen1207','nguyen275','nguyenan113','nguyenbinhtuyenk29','nguyenchinh2302','nguyencongtien','nguyendinhchien','nguyendinhhien2','nguyendinhsonspro','nguyenduccuong','nguyenhienuy','nguyenhongnhat','nguyenistoresg','nguyenkhacdoan','nguyenkhang100813','nguyenlongbh','nguyenluan2808','nguyenminh9999','nguyennhatvnb','nguyenphong','nguyenphuoctvt','nguyenquanghung','nguyenthanhhuong','nguyenthanhluanpq','nguyenthemanh0111','nguyentronguy','nguyenvu240989','nguyenxuanchung789','nguyenxuantam','nguyenxuanthuy','nguyetphham91','ngvanthieu94','nhanluanpro','nhantran','nhattinvt','nhngl','nhoccoibg','nhoxiuem','nhozharass002','nhuandatdida','nhuandatdida22','nhuquynh123','nk110289','nltn1995','nmc1998','nocturne92','noreply','nqtrinhtth','nthanhoang1809','ntkdalat','nvcdev','nvdtth','nvh010980','nvkha19','nvkha20','olala123','ongtoy1997','optical37na','pappertran','pdkhuong','phainhac','phamanhvunguyen','phambahoang666','phamcuong2016','phanleson','phantom002','phanvanhan','phatduoc989','phidieen01','phidieen02','phongclass','phtienlinh','phuc0935','phuc0936','phuctan342','phuongchicken93','phuongmeo','phuongmiracle1','phuongnt3011','phuongthaothao','phv1901','pkailomech','prolan9411','quachlamquoctien','quangbato12','quangdinh88','quanghuy291989','quangnhan','quangthang2641','quangvinhc5','quanphomer123','quocan2002','quocbaoasia123','quocdung1989','quockiencoltd','quocnp1506','quocvulhvl','quy200688','quy200689','quyenttq1004','quyenvv','quyuyen','ranzonepro','remesouth','richdadnghiem','richdadquan2016','rickowens','rincao','ringjupiter','roadtomillionair02','rosestorm1','royalvn','ruabien','ruby2015','sanghuynh01','sangktts','sanglee99s','sangnguyendev','satthunasa2','sbenforlife','seacafl','sevenup024','shenglong','sogoku111','songpro','sonpro1999','sontqinfo','steveparker','sunbaekue','t01234681235','t2dung','tai88o','taigamevemay','tamhoi14','tamnguyen224pb1993','tanduy135','tanlead','tantrucads','taovps15','tdkmmo','tencha1007','thaisondhktkt','thaitrandng','thangbka92','thangnguyen182','thangphaphach','thangutsport','thanhbt12','thanhdat182195','thanhduyit','thanhlevhg','thanhnga86','thanhnguyen229','thanhtrammo','thanhtruc68','thaovo','thegunner','thienbro93','thienhq1102','thiennhan213','thientin','thinhkid','thinhnv2','thjkjnoidi1','thuanbui','thuangpfa','thuemuanhadat','thuhodong','thuyanle','thuyhoang','tienichaz','tienpham005','tienphat','tieuphi','tieutuyen0602','tiloda063','tiloda0633','tk1vnd','tonnguyen','tonnystark001','tonyzetzet','totinhte','traantrung','tramminhthanh','trandinhthinhvisa','tranducdeptrai','tranduyen2710','trangxiboocnho','tranhuy1603','tranthao333','tranvanchienhn','trauvang2412','trinhmai','trongbao2102','tronghai1986','trongphu2508','trtung901','truclinh0707','trungan69','trunghieummo','trungnam','truonggiangdttn1','truongoaoa','ttkasease111','tu96com','tuan27123','tuan4884','tuananhleho1994','tuananhxautrai','tuanelkun','tuannam','tubanme115','tulenh4sao','tungdaigia','tunghuyen','tungphn','tuongphung','tuvatube','tuyenkhac1994','tuyetmiennhietdoi','tuyphong1982','tytsd1','uhdang','uhdang13','uyenkieu82','vandat1995','vanthangpro','vanthuong890','vantien0812','vantien9x','vanvietsm','vibetastudio','vietanh920','vietdigis','viethang','vietnguyen001','viruscua94','vitdien','vkool1404','vmphuc1812','vodien95','vodoanson90','vodung0801','vonglong11','vothailam123123','vovanluc','vudeptrai','vudinhtaui17','vuhoanganh','vuthuan33','vutrulavotann','vutuananh821987','vuvandung','vuvansuc','vynd','whisky29','win131','winds2070','wisea246','xatthukg12','xduyen87','xemgihomnay','xuanchc','xuantam2015','xuantheu','yanbituananh','zaizai1907','zazacon1995','zoombiekmon')
GROUP BY publisher_id, conversion_month, offer_id order by conversion_month, publisher_id