mysql> select * from information_schema.processlist where command = 'Query'\G
*************************** 1. row ***************************
     ID: 12710434
   USER: radio
   HOST: 172.27.11.93:34574
     DB: zenoradio-v25
COMMAND: Query
   TIME: 0
  STATE: Copying to tmp table
   INFO: 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-27'
                              and sc.date < '2015-08-28'
                              and de1.gateway_id = 17094
                      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 = 17094
      group by de.entryway_provider
      order by a.minutes desc