4,362
edits
Template:QualIN: Difference between revisions
no edit summary
No edit summary |
|||
| Line 1: | Line 1: | ||
{{#clear_external_data:}} | {{#clear_external_data:}} | ||
{{#get_db_data: db=engy | {{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: year|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: total|{{#external_value:ton}}}}{{#clear_external_data:}} | ||
|from=mrfin2020 | |||
|where=epr='{{{EPR}}}' | |||
|limit=1 | |||
|data=year=year | |||
}}{{#vardefine: year|{{# | |||
{{#clear_external_data:}} | |||
{{#get_db_data: db=engy | |||
|from=mrfin2020 | |||
|where=epr='{{{EPR}}}' | |||
|data=ton=sum(tonnes) | |||
}}{{#vardefine: total|{{#external_value:ton}}}} | |||
{{#clear_external_data:}} | |||
==Qualifying Waste Entering Site== | ==Qualifying Waste Entering Site== | ||
During {{#var:year}} the site received {{#var:total}} tonnes as qualifying material, as broken down below. | During {{#var:year}} the site received {{#var:total}} tonnes as qualifying material, as broken down below. | ||