     FROM  model_draft.ego_dp_supply_conv_powerplant
     WHERE scenario = 'NEP 2035'
     AND   capacity >= 0 
-    AND   fuel not in ('hydro', 'run_of_river', 'reservoir');
+    AND   fuel not in ('hydro', 'run_of_river', 'reservoir')
+    AND   version = 'v0.3.0';
 
 ALTER MATERIALIZED VIEW model_draft.ego_supply_conv_powerplant_nep2035_mview
     OWNER TO oeuser;

CREATE MATERIALIZED VIEW model_draft.ego_supply_res_powerplant_sq_mview AS
    SELECT *
    FROM model_draft.ego_dp_supply_res_powerplant
    WHERE scenario =  'Status Quo';

ALTER MATERIALIZED VIEW model_draft.ego_supply_res_powerplant_sq_mview
    OWNER TO oeuser;

		 AND scenario in ('NEP 2035', 'ego-nep2035')
		 ORDER BY id	
	) sub2
	Order by id
	AND version = 'v0.3.0';
-- 01:56:3626 hours execution time.

ALTER MATERIALIZED VIEW model_draft.ego_supply_res_powerplant_nep2035_mview
