 		SELECT *,
 		max(v_nom) OVER (PARTITION BY country) AS max_v_nom,
 		row_number() OVER () + (SELECT max(load_id)
-					FROM calc_ego_hv_powerflow.load
+					FROM model_draft.ego_grid_pf_hv_load
 					WHERE scn_name = 'Status Quo') AS load_id
 		FROM calc_ego_neighbouring_states.bus
 		) SQ

	GROUP BY generator_id;

*/
-- SELECT * FROM calc_ego_hv_powerflow.load WHERE bus > 280000;
DELETE FROM calc_ego_hv_powerflow.load WHERE bus > 280000;

-- INSERT neigbouring states in load table
-- Status Quo
INSERT into calc_ego_hv_powerflow.load (scn_name, load_id, bus, sign)

	SELECT
	scn_name,

		AND A.type = 'from_bus'
		AND A.scenario_id = 6
		) SQ
		JOIN model_draft.ego_grid_pf_hv_load C on (C.bus = SQ.bus_id)
	WHERE SQ.v_nom = SQ.max_v_nom
	AND C.scn_name = 'Status Quo'
	GROUP BY C.load_id;

-- NEP 2035
/*
INSERT INTO model_draft.ego_grid_pf_hv_load_pq_set (scn_name, load_id, temp_id, p_set)

	SELECT
	'NEP 2035' AS scn_name,
