select
	rtlmg.ani_e164,
	rtlmg.did_e164,
	rtlmg.carrier_title,
	dep.title clec,
	rtmr.entryway_provider
from reachout_tab_listener_minutes_by_gateway rtlmg
	left join data_entryway de on de.did_e164 = rtlmg.did_e164
	left join data_entryway_provider dep on dep.id = de.entryway_provider
	left join reachout_tab_mapping_rule rtmr on rtmr.carrier_title = rtlmg.carrier_title
where rtlmg.gateway_id = 525
	and rtlmg.ani_e164 not in (
		select phone_number
		from admin_dnc_list
	)
	and rtlmg.ani_e164 not in (
		select phone_number
		from reachout_tab_campaign_listener
		where date(campaign_date) > '2015-06-07'
	)
group by rtlmg.ani_e164,
	rtlmg.carrier_title
order by rtlmg.created_at desc