Public feed #894091

Something

public text v1 · immutable
Raw Edit
·published 2008-02-06 17:57 UTC
rendered paste body
SELECT
        (c.billsec/60) AS ttime,
        c.dst AS dest,
        UNIX_TIMESTAMP(c.calldate) as ctime,
        c.accountcode
FROM
        cdr c
WHERE
        c.lastapp = 'Dial'
AND  
        c.disposition = 'ANSWERED'
AND
        c.accountcode IS NOT NULL
AND
        c.src = 7099
AND
        (c.calldate BETWEEN FROM_UNIXTIME(1202256000) AND FROM_UNIXTIME(1202298498))