beowulf1416

Untitled

Dec 10th, 2015
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. mysql> select
  2. -> ifnull(round(sum(log.seconds)/60),0) sum_minutes
  3. -> from zenoreport.v2v25log log
  4. -> left join `zenoradio-v25`.data_listener_ani dla on log.ani = dla.ani_e164
  5. -> left join `zenoradio-v25`.data_listener_ani_carrier dlac on dla.carrier_id = dlac.id
  6. -> left join `zenoradio-v25`.data_entryway de on log.did = de.did_e164
  7. -> where date(log.date_start) >= '2015-10-01'
  8. -> and date(log.date_start) <= '2015-10-31'
  9. -> and de.entryway_provider = 75;
  10. +-------------+
  11. | sum_minutes |
  12. +-------------+
  13. | 35947620 |
  14. +-------------+
  15. 1 row in set (29.07 sec)
  16.  
  17. mysql> select
  18. -> ifnull(round(sum(log.seconds)/60),0) sum_minutes
  19. -> from zenoreport.v2v25log log
  20. -> left join `zenoradio-v25`.data_entryway de on log.did = de.did_e164
  21. -> where date(log.date_start) >= '2015-10-01'
  22. -> and date(log.date_start) <= '2015-10-31'
  23. -> and de.entryway_provider = 75;
  24. +-------------+
  25. | sum_minutes |
  26. +-------------+
  27. | 35847922 |
  28. +-------------+
  29. 1 row in set (17.22 sec)
Advertisement
Add Comment
Please, Sign In to add comment