Запрос на выбор блоков для обработки для деманда MediaSniper (161)

SELECT
    user_id, email, site_id, url_domain, STATUS, site_area_id, site_area_name, parent_site_area_id, is_base, block_type,
    demand_source_id, NAME,
    dfp_special_sizes,
    adv_expense_base_3, adv_expense_base_1 FROM (
    SELECT bisa.user_id, u.email, s.site_id, s.url_domain, sdss2.status,
           CONVERT(areas.site_area_id, CHAR) AS site_area_id,
           sa.name AS site_area_name,
           asa.site_area_id AS parent_site_area_id,
           asa.site_area_id IS NULL AS is_base,
           sad.block_type,
           ds.demand_source_id, ds.name,
           sad.dfp_special_sizes,
           bisa.adv_expense_base_3, bisa.adv_expense_base_1
    FROM (
        SELECT sad.site_area_id
        FROM rabota_db.site_area_design_24 sad
        INNER JOIN rabota_db.adfox_site_area_settings adfs ON sad.site_area_id = adfs.site_area_id AND adfs.adfox_status = 1
        JOIN rabota_db.site_area_demand_source_settings sds ON sad.site_area_id = sds.site_area_id AND sds.demand_source_id IN (127, 133)
        GROUP BY sad.site_area_id
    ) AS areas
    JOIN rabota_db.site_area sa ON sa.site_area_id = areas.site_area_id
    LEFT JOIN rabota_db.site_area_design_24 sad ON sad.site_area_id = areas.site_area_id
    JOIN bi.site_area bisa ON bisa.site_area_id = sa.site_area_id AND bisa.impressions_3 > 0
    JOIN rabota_db.user u ON u.user_id = bisa.user_id
    JOIN rabota_db.site s ON s.site_id = bisa.site_id
    JOIN rabota_db.demand_source ds ON ds.disabled = 0 AND ds.demand_source_type = 'adfox_header_bidding' AND ds.demand_source_id=161
    LEFT JOIN rabota_db.site_demand_source_status sdss ON ds.demand_source_id = sdss.demand_source_id AND sa.parent_id = sdss.site_id AND sdss.status NOT IN ('active', 'new')
    LEFT JOIN rabota_db.site_area_demand_source_settings sads ON sads.site_area_id = areas.site_area_id AND sads.demand_source_id = ds.demand_source_id
    LEFT JOIN rabota_db.site_demand_source_status sdss2 ON ds.demand_source_id = sdss2.demand_source_id AND sa.parent_id = sdss2.site_id
    LEFT JOIN rabota_db.attached_site_areas asa ON asa.attached_site_area_id = areas.site_area_id
    WHERE sdss.demand_source_id IS NULL AND sads.demand_source_id IS NULL AND sad.is_amp = 0 AND sad.is_turbo = 0
    GROUP BY bisa.user_id, s.site_id, s.url_domain, areas.site_area_id, sdss2.status, ds.demand_source_id, ds.name
)  q WHERE (1=1)
;