select
	a.seconds,
	a.did_e164,
	a.clec,
	a.carrier_title
from
	(
		select
			de.did_e164,
			sc.entryway_id,
			dep.title as clec,
			rtmr.carrier_title,
			sum(sc.seconds) as seconds
		from summary_call sc
			left join data_entryway de on de.id = sc.entryway_id
			left join data_entryway_provider dep on dep.id=entryway_provider
			inner join reachout_tab_mapping_rule rtmr on dep.title = rtmr.entryway_provider
		where sc.entryway_id in
			(
				select
					id
				from data_entryway
				where gateway_id=525
					and is_deleted=0
					and did_e164 NOT LIKE '1700%'
					AND did_e164 NOT LIKE '1600%'
			)
			and date >= '2015-04-14'
			and date < '2015-04-15'
		group by did_e164
		order by sum(seconds) desc
	) a
group by a.clec
order by seconds desc