Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- calldate,src,dst,dstchannel,(billsec/60),disposition,uniqueid
- FROM cdr
- WHERE billsec >=4
- AND convert(calldate, date) BETWEEN '$ano_i-$mes_i-$diba_i' and '$ano_f-$mes_f-$dia_f'
- AND src = $src
- AND dstchannel REGEXP '(^.*[SIP]\/[a-zA-Z]{3})'
- AND dst REGEXP '^.{3}[5-9]{1}.*' OR '^.{1}9[0-9]{8}'
- ORDER BY calldate;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement