Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2015-08-18 16:39:17 ERROR ERROR : Delayed::WorkerTimeout: execution expired (Delayed::Worker.max_run_time is only 600 seconds):
- select
- a.minutes,
- de.did_e164,
- dep.title clec,
- a.carrier_title
- from data_entryway de
- inner join data_entryway_provider dep on de.entryway_provider = dep.id
- left join (
- select
- sc.entryway_id,
- dlac.title carrier_title,
- sum(sc.seconds / 60) minutes
- from summary_call sc
- inner join data_listener_ani_carrier dlac on dlac.id = sc.listener_ani_carrier_id
- where sc.date >= '2015-08-17'
- and sc.date < '2015-08-18'
- group by sc.entryway_id
- ) a on de.id = a.entryway_id
- left join reachout_tab_mapping_rule rtmr on dep.title = rtmr.entryway_provider and a.carrier_title = rtmr.carrier_title
- where de.is_deleted = 0
- and substr(de.did_e164,1,4) not in ('1600','1700')
- and dep.title in
- (
- select distinct rtmr2.entryway_provider
- from reachout_tab_mapping_rule rtmr2
- )
- and de.gateway_id = '618'
- group by de.entryway_provider
- order by a.minutes desc
Advertisement
Add Comment
Please, Sign In to add comment