# tail -f hsdb-slow.log
# Time: 140429  8:31:43
# User@Host: cron[cron] @  [72.52.126.206]
# Query_time: 4.651273  Lock_time: 0.000071 Rows_sent: 20  Rows_examined: 3724132
SET timestamp=1398785503;
SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,reset_time,DATE_FORMAT(expiration_date,'%Y%m%d') from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id  group by list_id order by list_id;
# Time: 140429  8:52:08
# User@Host: cron[cron] @  [72.52.126.201]
# Query_time: 3.736130  Lock_time: 0.010943 Rows_sent: 500  Rows_examined: 1104205
SET timestamp=1398786728;
SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code FROM vicidial_list where called_since_last_reset='N' and status IN('PU','PDROP','ERI','LRERR','DNC','DNCC','AHS','NP','DNSE','DNQ','DROP','AB','NI','XDROP','NA','AL','AM','DEC','N','B','A','AA','NEW') and list_id IN('122') and lead_id NOT IN('13805655','14233840','14648836','12921097','12698378','12839459','13036354','15112853','15123168','12868866','13308668','14683840','14686126','13053358','12723838','14753041','13245676','14121059','14211651','12885467','15113123','12998704','14089089','12918498','12808324','12697040','12999135','12782228','12921779','12764888','14650628','13290773','12793174','14220299','13049428','14769867','13788911','13303277','14088419','14765939','13797967','14224187','12908676','14685815','12671899','12987353','12846678','12755822','12764649','14216361','12828381','12871489','12908775','14793210','13023122','14244271','12771142','14220312','13013851','12748315','14233529','12986215','12802508','12683916','13046557','13311666','12968991','14213651','14771608','12793772','14245287','12759234','14755968','12866912','13255760','12986393','12727977','14225189','12753634','13296922','12970303','13293380','13792783','13014869','13007563','12900956','13278647','13314483','12796164','12772813','14748489','14239012','13311214','12680009','13264032','12698465','12717903','12921965','12881941','15109441','12724026','12707498','12941218','13128571','12864338','12693108','12956449','12708694','14208193','13804399','13720421','12897545','12963993','12866305','14653323','12948891','14212370','12711181','14117825','13255849','12678792','14238643','12697238','12698433','12973866','13136862','12988573','15113532','13132045','12729718','14653964','14117843','12744259','13047876','12826496','12816928','12921424','13036561','12709335','12968737','14656309','13799435','12939861','13138322','12713619','15118100','13033986','13136063','12858505','12715659','13288657','12823676','13012605','12742101','14650442','12989720','12828450','14791814','12954038','13789996','12822978','12824430','13014764','12820065','12976818','13278269','13297237','13246982','13028394','13129481','13027396','14791986','12750678','14773166','12789197','12937429','14685147','12795553','13720229','14655976','12797027','13248752','12875085','12724397','13026300','13252493','13262302','12979383','12874401','12879485','15109990','13254748','13797689','14746224','12987099','12706240','12967284','13301077','12706210','12803091','12968655','12686755','12823230','12948641','12764894','13285152','12852945','14216485','12784445','12847372','12884723','14746473','14087608','12767184','13039553','12941443','14760289','12791832','14247273','12991544','13016175','15106711','12906368','13021054','15112717','14790723','13016614','12729248','12953903','14234535','15125021','12696448','12723456','14239882','15111760','15111275','13302721','12920911','13801309','12847901','12693308','14211035','12884141','14792512','12839952','12979711','13011620','12822366','15122566','14683295','12965732','12755195','12720720','15110814','12856926','12966615','13137147','13281527','12747144','13259718','12764542','13798955','13277722','12676211','14218094','12679760','13132434','12974769','12865589','14793325','13049422','12705839','12914951','12803360','13261463','14242341','12878709','14227276','13031088','12701481','12880513','12735111','12753082','14238308','12723174','13277682','12710100','12681217','13019556','12753993','14215521','12992983','13129894','13130930','14686662','13273351','13052445','13035553','12919501','13795917','14119092','12699712','12985073','12862553','12965480','13047714','14217461','12802125','12954810','12822397','14756043','12778259','13269460','13020764','14233070','13796156','13794731','12797151','12704010','12706460','14224036','13138580','12771941','14773878','12753091','12939935','14242793','12896324','13717303','12687081','12723575','12819268','12953591','12955609','12940846','13305878','13252710','15115484','13026246','12779266','12791003','15109776','13273935','13285979','12890953','15105675','13795381','12715401','12764000','12857820','15108679','12869804','12723108','12812705','15121268','13792623','12713821','12803831','14112938','12882404','13034959','12780962','14221628','13796561','12907813','13245969','12848406','12671766','12692161','14212715','14768007','14119139','12811559','14231203','12680321','13792774','12977906','12998929','14767988','13015548','12945450','13029538','12846490','12907018','13271448','12998495','13137232','13791882','12979292','12733342','12842359','13268063','12902858','13246406','12993572','13049001','13042892','14113284','12814987','15115325','12952786','12722219','12765232','12904637','12784535','12806116','13129114','14210661','13137323','13794194','12785418','13279707','12749761','13030351','12845854','12713377','13281120','13301870','12786119','12956572','13132805','12763591','12777319','12968336','12955397','12870171','12686824','12833510','14236096','14215417','12785677','13027393','12919314','12917337','12861281','12799943','13794397','12955171','14229479','13046971','12970988','12817536','12864767','13039762','13047533','13256137','14745387','14653368','12814368','12769979','13024185','13310785','13253088','13007686','12896434','12990262','12900983','12886011','12787331','13017344','12817850','12999447','13009025','12720643','14756653','13256259','12903596','12991004','12935710','13804240','12838162','14651265','12997173','13246366','13012442','12919140','12766279','14228273','12699022','12698501','12921615','14243533','13026171','12738790','13246203','12983986','13019207','14116810','12679917','12765273','13256216','14218780','12918314','12754811','13038593','0')  and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) )    order by RAND() limit 500;