ADMIN CHANGE LOG: Record Detail - 1756
DIFF TO LAST CHANGE
ID: 1614 DATE TIME: 2026-08-21 12:05:22 USER: 6666
| 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| |