select
	dep.title clec,
	a.carrier_title,
	de.did_e164,
	a.minutes
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-01-01'
			and sc.date < '2015-04-16'
		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 = 87
group by de.entryway_provider, de.did_e164
order by a.minutes desc