Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select
- -> ifnull(round(sum(log.seconds)/60),0) sum_minutes
- -> from zenoreport.v2v25log log
- -> left join `zenoradio-v25`.data_listener_ani dla on log.ani = dla.ani_e164
- -> left join `zenoradio-v25`.data_listener_ani_carrier dlac on dla.carrier_id = dlac.id
- -> left join `zenoradio-v25`.data_entryway de on log.did = de.did_e164
- -> where date(log.date_start) >= '2015-10-01'
- -> and date(log.date_start) <= '2015-10-31'
- -> and de.entryway_provider = 75;
- +-------------+
- | sum_minutes |
- +-------------+
- | 35947620 |
- +-------------+
- 1 row in set (29.07 sec)
- mysql> select
- -> ifnull(round(sum(log.seconds)/60),0) sum_minutes
- -> from zenoreport.v2v25log log
- -> left join `zenoradio-v25`.data_entryway de on log.did = de.did_e164
- -> where date(log.date_start) >= '2015-10-01'
- -> and date(log.date_start) <= '2015-10-31'
- -> and de.entryway_provider = 75;
- +-------------+
- | sum_minutes |
- +-------------+
- | 35847922 |
- +-------------+
- 1 row in set (17.22 sec)
Advertisement
Add Comment
Please, Sign In to add comment