Create new nodes

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;