select
	a.did_e164,
	a.clec,
	rtlmg.carrier_title,
	sum(rtlmg.minutes) minutes,
	case when rtmr.entryway_provider is null
		then 'FCC/PINERIDGE'
		else rtmr.entryway_provider
	end default_clec
from
	(
	select
		de.gateway_id,
		de.did_e164,
		dep.title clec
	from data_entryway de
		inner join data_entryway_provider dep on dep.id = de.entryway_provider
	where de.is_deleted = 0
		and substr(de.did_e164, 1, 4) not in ('1600','1700')
		and de.gateway_id = 525
	) a
	left join reachout_tab_listener_minutes_by_gateway rtlmg on a.did_e164 = rtlmg.did_e164 and a.gateway_id = rtlmg.gateway_id
	left join reachout_tab_mapping_rule rtmr on rtlmg.carrier_title = rtmr.carrier_title and rtlmg.did_title = rtmr.entryway_provider
where rtlmg.gateway_id = 525
group by a.did_e164