| SQL | UPDATE vicidial_report_log set run_time='0.039435' where report_log_id='11144'
SELECT vl.call_date,vl.phone_number,vi.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,UNIX_TIMESTAMP(vl.call_date),vl.status from vicidial_users vu,vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-08-01 00:00:00' and vl.call_date <= '2026-08-31 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') and (vl.user_group IN('ADMIN' ,'test') or vl.user_group is null) and vi.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 vl.call_date desc limit 500000
|
| UPDATE vicidial_report_log set run_time='0.052432' where report_log_id='8208'|SELECT vl.call_date,vl.phone_number,vi.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,UNIX_TIMESTAMP(vl.call_date),vl.status from vicidial_users vu,vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-07-26 00:00:00' and vl.call_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' |
UPDATE vicidial_report_log set run_time='0.039435' where report_log_id='11144'|SELECT vl.call_date,vl.phone_number,vi.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,UNIX_TIMESTAMP(vl.call_date),vl.status from vicidial_users vu,vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-08-01 00:00:00' and vl.call_date <= '2026-08-31 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' |
'998''999''1001''1111''51099''17072026' |
| '123456789') and vl.campaign_id IN('16071''AGENTDIRECT''AGENTDIRECT_CHAT') and (vl.user_group IN('ADMIN' |
'123456789') and vl.campaign_id IN('16071') and (vl.user_group IN('ADMIN' |
| 'test') or vl.user_group is null) and vi.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 vl.call_date desc limit 500000| |
'test') or vl.user_group is null) and vi.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 vl.call_date desc limit 500000| |
|