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 '2019-01-01' and '2019-01-10'
- AND src = 1000
- AND dstchannel REGEXP '(^.*[SIP]\/[a-zA-Z]{3})'
- AND dst REGEXP '^.{3}[5-9]{1}.*' OR '^.{1}9[0-9]{8}'
- ORDER BY calldate;
Add Comment
Please, Sign In to add comment