 			AND version = 'v0.3.0'
 			AND generation_type not in ('biomass','gas','reservoir','run_of_river')
 			AND flag in ('commissioning', 'repowering')
+			AND generation_subtype not in ('wind_offshore')
 			Group BY id
 			Order by id)
 		 AND scenario in ('NEP 2035')

		 AND version = 'v0.3.0'
		 AND electrical_capacity > 0
		 AND generation_type in ('solar','wind')
		 ORDER BY id	
		 ) as sub
	UNION 
	SELECT
	sub2.*
	FROM  ( 
		SELECT  DISTINCT ON (id)

-- MView for eGo 100
DROP MATERIALIZED VIEW IF EXISTS supply.ego_dp_res_powerplant_ego100_mview CASCADE;
CREATE MATERIALIZED VIEW supply.ego_dp_res_powerplant_ego100_mview AS
	SELECT DISTINCT ON (id)
	sub.*
	FROM  ( 
		SELECT DISTINCT ON (id)
