UPDATE vicidial_report_log set run_time='0.005799' where report_log_id='8167'
SELECT vl.call_date,vl.phone_number,vl.status,vl.user,vu.full_name,vl.campaign_id,vi.vendor_lead_code,vi.source_id,vi.list_id,vi.gmt_offset_now,vi.phone_code,vi.phone_number,vi.title,vi.first_name,vi.middle_initial,vi.last_name,vi.address1,vi.address2,vi.address3,vi.city,vi.state,vi.province,vi.postal_code,vi.country_code,vi.gender,vi.date_of_birth,vi.alt_phone,vi.email,vi.security_phrase,vi.comments,vl.length_in_sec,vl.user_group,vl.queue_seconds,vi.rank,vi.owner,vi.lead_id,vl.closecallid,vi.entry_list_id,vl.uniqueid,val.campaign_id, ifnull(val.dispo_sec+val.dead_sec,0),entry_date,vl.called_count,last_local_call_time,modify_date,called_since_last_reset from vicidial_users vu,vicidial_list vi,vicidial_closer_log vl LEFT OUTER JOIN vicidial_agent_log val ON vl.uniqueid=val.uniqueid and vl.lead_id=val.lead_id and vl.user=val.user where vi.entry_date >= '2026-07-26 00:00:00' and vi.entry_date <= '2026-08-21 23:59:59' and vu.user=vl.user and vi.lead_id=vl.lead_id and vl.list_id IN('510' ,'998' ,'999' ,'1001' ,'1111' ,'51099' ,'17072026' ,'123456789') and vl.campaign_id IN('16071' ,'AGENTDIRECT' ,'AGENTDIRECT_CHAT' ,'REMOTEINBOUND' ,'testalex') and vl.user='1607' and (vl.user_group IN('ADMIN' ,'test') or vl.user_group is null) and vl.status IN('A' ,'AA' ,'AB' ,'ADAIR' ,'ADC' ,'ADCT' ,'AFAX' ,'AFTHRS' ,'AL' ,'AM' ,'B' ,'CALLBK' ,'CBHOLD' ,'DAIR' ,'DC' ,'DEC' ,'DNC' ,'DNCC' ,'DNCL' ,'DROP' ,'ERI' ,'INCALL' ,'IQNANQ' ,'IVRXFR' ,'LRERR' ,'LSMERG' ,'MAXCAL' ,'MLINAT' ,'N' ,'NA' ,'NANQUE' ,'NEW' ,'NI' ,'NP' ,'PDROP' ,'PM' ,'PU' ,'QCFAIL' ,'QUEUE' ,'QVMAIL' ,'RQXFER' ,'SALE' ,'SVYCLM' ,'SVYEXT' ,'SVYHU' ,'SVYREC' ,'SVYVM' ,'TIMEOT' ,'XDROP' ,'CB2') order by vi.entry_date asc limit 1000000