DROP TEMPORARY TABLE IF EXISTS sa_with_external_nodes;
CREATE TEMPORARY TABLE sa_with_external_nodes (PRIMARY KEY (site_area_id))
SELECT DISTINCT sa.site_area_id FROM rabota_db.site_area sa 
JOIN site s ON sa.parent_id = s.site_id
RIGHT JOIN rabota_db.site_area_demand_source_settings sds ON sa.site_area_id = sds.site_area_id
WHERE sa.parent_id = 216564
AND 
(
sa.use_header_bidding = 1 
OR
s.use_header_bidding = 1
)
AND sds.chain_status <> 1
AND sds.status <> 1
AND sds.deleted <> 0
AND sds.end_date_ptz IS NOT NULL
;

SELECT * FROM sa_with_external_nodes;


DROP TEMPORARY TABLE IF EXISTS sa_without_external_nodes;
CREATE TEMPORARY TABLE sa_without_external_nodes (PRIMARY KEY (site_area_id))
SELECT sa.site_area_id FROM rabota_db.site_area sa 
LEFT JOIN
   sa_with_external_nodes saen ON saen.site_area_id = sa.site_area_id
WHERE sa.parent_id = 216564
AND saen.site_area_id IS NULL
;

SELECT * FROM sa_without_external_nodes;

INSERT INTO rabota_db.`site_area_demand_source_settings` (
    `site_area_id`, 
    `demand_source_id`, 
    `status`, 
    `chain_id`, 
    `chain_type`, 
    `chain_status`, 
    `order`, 
    `manual_percent`,
    `modify_date`,
    `start_date_ptz`
)
    SELECT
        sa.`site_area_id`,
        2,
        1,
        1,
        'manual',
        1,
        1,
        100,
        NOW() AS modify_date,
        DATE(NOW()) AS start_date_ptz
      
FROM sa_without_external_nodes sa;