select ani_e164, rtmg.did_e164, carrier_id, carrier_title, dep.title
from reachout_tab_listener_minutes_by_gateway rtmg
	inner join data_entryway de on rtmg.did_e164 = de.did_e164
	inner join data_entryway_provider dep on de.entryway_provider = dep.id
where rtmg.gateway_id = 4633
	and created_at >= '2015-01-01'
	and minutes >= 30
	and rtmg.ani_e164 not in (
		select phone_number
		from admin_dnc_list
	)
	and rtmg.ani_e164 not in (
		select phone_number
		from reachout_tab_campaign_listener
		where date(campaign_date) > '2015-04-04'
	)
group by de.title