Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
SELECT count(*) as 'Rows' , c.`dialstatus`, c.`hangup_cause`, l.`status` as 'log status', i.`status` as 'list status' FROM `vicidial_carrier_log` c
JOIN vicidial_log l ON c.uniqueid=l.uniqueid
JOIN vicidial_list i ON i.lead_id=l.lead_id
WHERE c.`dialstatus` IN ('CONGESTION','CHANUNAVAIL') AND c.`call_date` >= DATE_SUB(NOW(), INTERVAL 1 DAY)
GROUP BY c.`dialstatus`, c.`hangup_cause`, l.`status`, i.`status` ORDER BY c.`dialstatus`, c.`hangup_cause`, l.`status`, i.`status`;
DomeDan wrote:Thats a good question, I don't know.
I would like to see an answer to that too... but well I'm using it after I patched FastAGI_log.pl
Users browsing this forum: No registered users and 53 guests