select
         a.minutes,
        de.did_e164,
        dep.title clec,
        a.carrier_title
      from data_entryway de
              inner join data_entryway_provider dep on de.entryway_provider = dep.id
              left join (
                      select
                              sc.entryway_id,
                              dlac.title carrier_title,
                              sum(sc.seconds / 60) minutes
                      from summary_call sc
                              inner join data_listener_ani_carrier dlac on dlac.id = sc.listener_ani_carrier_id
			inner join data_entryway de1 on sc.entryway_id = de1.id
                      where sc.date >= '2015-08-17'
                              and sc.date < '2015-08-18'
															and de1.gateway_id = 618
                      group by sc.entryway_id
              ) a on de.id = a.entryway_id
              left join reachout_tab_mapping_rule rtmr on dep.title = rtmr.entryway_provider and a.carrier_title = rtmr.carrier_title
      where de.is_deleted = 0
              and substr(de.did_e164,1,4) not in ('1600','1700')
              and dep.title in
              (
                      select distinct rtmr2.entryway_provider
                      from reachout_tab_mapping_rule rtmr2
              )
              and de.gateway_id = 618
      group by de.entryway_provider
      order by a.minutes desc