Advertisement
somedeadman

Untitled

Jun 25th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT *, TIMESTAMP(FROM_UNIXTIME(startTime)) t
  2. FROM binotel_daemon.`call` c
  3. WHERE
  4. DATE(FROM_UNIXTIME(startTime)) = '2018-06-25'
  5. AND c.disposition = 'BUSY'
  6. AND c.callType = 0
  7. AND c.internalNumber > 0
  8. GROUP BY c.did
  9. ORDER BY t
  10. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement