Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *, TIMESTAMP(FROM_UNIXTIME(startTime)) t
- FROM binotel_daemon.`call` c
- WHERE
- DATE(FROM_UNIXTIME(startTime)) = '2018-06-25'
- AND c.disposition = 'BUSY'
- AND c.callType = 0
- AND c.internalNumber > 0
- GROUP BY c.did
- ORDER BY t
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement