Template:LADestinations: Difference between revisions

From WikiWaste
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
=== Significant Tonnage Summary<ref>Tonnages under 2000 tonnes have been screened out.</ref> ===
=== Significant Tonnage Summary<ref>Tonnages under 2000 tonnes have been screened out.</ref> ===
{{#switch: {{#sub: {{{gss}}}|0|1}}
{{#get_db_data: db=disp | from=disposal | where=gsscode='{{{gss}}}'|limit=1|data=date=date}}
|E = {{#vardefine: sel | eng}}
|S = {{#vardefine: sel | sco}}
|W = {{#vardefine: sel | wal}}
}}{{#get_db_data: db=disp | from=disposal | where=country='{{#var:sel}}'|limit=1|data=date=date}}
Data comes from [[WasteDataFlow]] for the period {{#external_value:date}}.{{#clear_external_data:}}
Data comes from [[WasteDataFlow]] for the period {{#external_value:date}}.{{#clear_external_data:}}
{{#get_db_data: db=disp |from=disposal |where=gsscode='{{{gss}}}' and tonnage >= 2000|order by=stream, tonnage desc|data=stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage}}
{{#get_db_data: db=disp |from=disposal |where=gsscode='{{{gss}}}' and tonnage >= 2000|order by=stream, tonnage desc|data=stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage}}

Latest revision as of 04:35, 8 July 2022

Significant Tonnage Summary[1]

Data comes from WasteDataFlow for the period Error: no local variable "date" has been set..

Stream Facility Operator Address Material Tonnes
  1. Tonnages under 2000 tonnes have been screened out.