select
	dep.title clec,
	dlac.title,
	de.did_e164,
	sum(sc.seconds / 60) minutes
from summary_call sc
	inner join data_entryway de on de.id = sc.entryway_id
	inner join data_entryway_provider dep on dep.id = de.entryway_provider
	inner join data_listener_ani_carrier dlac on dlac.id = sc.listener_ani_carrier_id
where sc.date >= '2015-04-13'
	and sc.date < '2015-04-14'
	and de.is_deleted = 0
	and substr(de.did_e164,1,4) not in ('1600','1700')
	and de.gateway_id = 9532
group by dep.id,de.did_e164
order by minutes desc