Anonymous

                        SELECT
                                SUM(c.billsec/60) AS ttime,  
                                COUNT(c.uniqueid) AS tcalls, 
                                c.clid AS emp,
                                c.src as ext  
                        FROM
                                cdr c
                        LEFT JOIN
                                extentions x ON ((c.src=x.channel) OR (c.userfield=x.extention))
                        LEFT JOIN
                                employee e ON e.extention=x.extention
                        WHERE
                                c.lastapp = 'Dial'
                        AND  
                                c.disposition = 'ANSWERED'
                        AND
                                c.accountcode IS NOT NULL
                        AND
                                ((c.src BETWEEN '200' AND '299') OR (c.userfield BETWEEN '200' AND '299'))
                        AND
                                (c.calldate BETWEEN '2008-03-18 00:00:00' AND NOW())
                        GROUP BY c.src