SELECT 
    COALESCE(networks.name,'Unknown Network') AS network,
    SUM(requests) AS requests,
    SUM(impressions) AS impressions,
    COALESCE((SUM(impressions)/SUM(requests))*100,0) AS fill_rate,
    SUM(clicks) AS clicks,
    COALESCE((SUM(clicks)/SUM(impressions))*100,0) AS CTR,
    SUM(ad_place_revenue) AS publisher_revenue,
    COALESCE(SUM(ad_place_revenue)/(SUM(impressions)/1000) , 0) AS eCPM
   FROM (
    SELECT 
     sites.type,
     sites.user_id as client_id,
     property_id,
     ad_place_id,
     network_id,
     report_publisher_networks.requests,
     report_publisher_networks.impressions,
     report_publisher_networks.clicks,
     report_publisher_networks.ad_place_revenue
    FROM report_publisher_networks,sites
    WHERE(
     report_publisher_networks.date BETWEEN '2015-08-01' AND '2015-08-31'
     AND
     report_publisher_networks.property_id = sites.id
    )
   ) AS expanded_report left join networks on(network_id = networks.id)
   WHERE (`client_id` IN (9560))
   GROUP BY network_id
   ORDER BY impressions DESC