SELECT
DISTINCTc.uniqueid,
r.`name`,
r.CustomerPhone,
r.TocallerPhone,
r.bound,
r.Elapsed,
r.LastTime,
s.sourceName,
c.uniqueid,
c.recordingfile,
c.calldate
FROM
cdrc
JOINrecordInforONc.uniqueid=r.niqueid
LEFTJOINSourcesONr.callerIdNum=s.MobileNum
WHERE
1=1
ANDc.disposition!='NOANSWER'
LIMIT0,10
SELECT
count(DISTINCTuniqueid)
FROM
cdrc
JOINrecordInforONc.uniqueid=r.niqueid
LEFTJOINSourcesONr.callerIdNum=s.MobileNum
WHERE
1=1
ANDc.disposition!='NOANSWER'
分 -->
|