select
	rtmr.carrier_title,
	rtmr.entryway_provider,
	rtmr.entryway_id,
	de.did_e164,
	rtlmg1.minutes
from reachout_tab_mapping_rule rtmr
	left outer join (
		select
			rtlmg.did_title,
			rtlmg.did_e164,
			sum(rtlmg.minutes) minutes
		from reachout_tab_listener_minutes_by_gateway rtlmg
			inner join data_entryway de on de.gateway_id = rtlmg.gateway_id and de.did_e164 = rtlmg.did_e164
		where rtlmg.gateway_id = 9532
			and de.is_deleted = false
			and de.did_e164 not like '%1700%'
			and de.did_e164 not like '%1600%'
		group by rtlmg.did_title, rtlmg.did_e164
	) rtlmg1 on rtmr.entryway_provider = rtlmg1.did_title
	inner join data_entryway_provider dep on dep.title = rtmr.entryway_provider
	inner join data_entryway de on de.entryway_provider = dep.id
where de.gateway_id = 9532
order by rtlmg1.minutes desc