Residual Waste EFW: Difference between revisions

Line 1:

{{#get_db_data: db=~~engy~~|from=~~efwdb | where=status='Operational'~~ | data=opt=~~sum(cap)~~}}

{{#vardefine: opston | {{#external_value:opt}}}}

{{#get_db_data: db=~~engy~~|from=~~efwdb | where=status='Under Construction'~~ | data=opt=~~sum(cap)~~}}

{{#vardefine: ucston | {{#external_value:opt}}}}

{{#get_db_data: db=~~engy~~|from=~~efwdb | where=status='Planning'~~ | data=opt=~~sum(cap)~~}}

{{#vardefine: planton | {{#external_value:opt}}}}

{{#get_db_data: db=~~engy~~|from=~~efwdb | where=status='Consultation Stage'~~ | data=opt=~~sum(cap)~~}}

{{#vardefine: conston | {{#external_value:opt}}}}

Line 22:

{{#get_db_data: db=mnk |from=energy.~~efwdb |where=status='Operational' and length(epr) > 2~~|data=site=site,id=id,cap=cap~~|order by=id~~}}

{{#get_db_data: db=mnk |from=energy.opsite |data=site=site,id=id,cap=cap}}

{|Class="wikitable sortable"

! ID !! Site Name !! Capacity (kt)

Line 144:

{{#get_db_data: db=~~engy~~ |from=~~efwdb |where=status='Under Construction'~~|data=site=site,id=id,cap=cap}}

{{#get_db_data: db=mnk |from=energy.ucsite |data=site=site,id=id,cap=cap}}

{|Class="wikitable sortable"

! ID !! Site Name !! Capacity (kt)

Line 172:

{{#get_db_data: db=~~engy~~ |from=~~efwdb |where=status='Planning' and cap > 0~~ |data=site=site,id=id,cap=cap}}

{{#get_db_data: db=mnk |from=energy.plsite |data=site=site,id=id,cap=cap}}

{|Class="wikitable"

! ID !! Site Name !! Capacity (kt)

Line 185:

===In Consultation===

{{#get_db_data: db=~~engy~~ |from=~~efwdb |where=status='Consultation Stage' and cap > 0~~ |data=site=site,id=id,cap=cap}}

{{#get_db_data: db=mnk |from=energy.consite |data=site=site,id=id,cap=cap}}

{|Class="wikitable sortable"

! ID !! Site Name !! Capacity (kt)

@@ Line 1: / Line 1: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=engy|from=efwdb | where=status='Operational' | data=opt=sum(cap)}}
+{{#get_db_data: db=mnk |from=energy.optot | data=opt=op_tot}}
 {{#vardefine: opston | {{#external_value:opt}}}}
 {{#clear_external_data:}}
-{{#get_db_data: db=engy|from=efwdb | where=status='Under Construction' | data=opt=sum(cap)}}
+{{#get_db_data: db=mnk |from=energy.uctot | data=opt=uc_tot}}
 {{#vardefine: ucston | {{#external_value:opt}}}}
 {{#clear_external_data:}}
-{{#get_db_data: db=engy|from=efwdb | where=status='Planning' | data=opt=sum(cap)}}
+{{#get_db_data: db=mnk |from=energy.pltot | data=opt=pl_tot}}
 {{#vardefine: planton | {{#external_value:opt}}}}
 {{#clear_external_data:}}
-{{#get_db_data: db=engy|from=efwdb | where=status='Consultation Stage' | data=opt=sum(cap)}}
+{{#get_db_data: db=mnk |from=energy.contot | data=opt=con_tot}}
 {{#vardefine: conston | {{#external_value:opt}}}}
@@ Line 22: / Line 22: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=mnk |from=energy.efwdb |where=status='Operational' and length(epr) > 2|data=site=site,id=id,cap=cap|order by=id}}
+{{#get_db_data: db=mnk |from=energy.opsite |data=site=site,id=id,cap=cap}}
 {|Class="wikitable sortable"
 ! ID !! Site Name !! Capacity (kt)
@@ Line 144: / Line 144: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=engy |from=efwdb |where=status='Under Construction'|data=site=site,id=id,cap=cap}}
+{{#get_db_data: db=mnk |from=energy.ucsite |data=site=site,id=id,cap=cap}}
 {|Class="wikitable sortable"
 ! ID !! Site Name !! Capacity (kt)
@@ Line 172: / Line 172: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=engy |from=efwdb |where=status='Planning' and cap > 0 |data=site=site,id=id,cap=cap}}
+{{#get_db_data: db=mnk |from=energy.plsite |data=site=site,id=id,cap=cap}}
 {|Class="wikitable"
 ! ID !! Site Name !! Capacity (kt)
@@ Line 185: / Line 185: @@
 ===In Consultation===
 {{#clear_external_data:}}
-{{#get_db_data: db=engy |from=efwdb |where=status='Consultation Stage' and cap > 0 |data=site=site,id=id,cap=cap}}
+{{#get_db_data: db=mnk |from=energy.consite |data=site=site,id=id,cap=cap}}
 {|Class="wikitable sortable"
 ! ID !! Site Name !! Capacity (kt)