 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';
+    WHERE scenario =  'Status Quo'
+    And version = 'v0.3.0';
 
 -- MView for NEP 2035
 DROP MATERIALIZED VIEW IF EXISTS model_draft.ego_supply_res_powerplant_nep2035_mview CASCADE;

			Group BY id
			Order by id)
		 AND scenario in ('NEP 2035', 'ego-nep2035')
		 ORDER BY id	
	) sub3
	Order by id;

    WHERE scenario = 'NEP 2035'
    AND   capacity >= 0 
    AND   fuel not in ('hydro', 'run_of_river', 'reservoir')
    AND shutdown IS NULL or shutdown >= 2034
    And version = 'v0.3.0';

-- MView for eGo 100
DROP MATERIALIZED VIEW IF EXISTS  model_draft.ego_supply_conv_powerplant_ego100_mview CASCADE;
