Template:EAIn: Difference between revisions

Revision as of 11:40, 16 July 2024

The query SELECT updated FROM `db_ea`.`ea_ew_in` WHERE epr='{{{EPR}}}' LIMIT 1 is invalid (Error 1049: Unknown database 'db_ea' Function: EDConnectorRdbms::fetch Query: SELECT updated FROM `db_ea`.`ea_ew_in` WHERE epr='{{{EPR}}}' LIMIT 1 ).The query SELECT tin FROM `db_ea`.`ea_ton_in` WHERE epr='{{{EPR}}}' is invalid (Error 1049: Unknown database 'db_ea' Function: EDConnectorRdbms::fetch Query: SELECT tin FROM `db_ea`.`ea_ton_in` WHERE epr='{{{EPR}}}' ).The query SELECT ewc,origin,tin FROM `db_ea`.`ea_ew_in` WHERE epr='{{{EPR}}}' is invalid (Error 1049: Unknown database 'db_ea' Function: EDConnectorRdbms::fetch Query: SELECT ewc,origin,tin FROM `db_ea`.`ea_ew_in` WHERE epr='{{{EPR}}}' ).

Waste Tonnage, By Origin

The table shows a list of the Waste for the Permit {{{EPR}}}, that has arrived into sites as reported to the Regulator and then publicised in their reported statistics. The Data used is from the most recent returns. The total reported tonnage arriving at the site was: Expression error: Unexpected < operator.t.

Where this tonnage exceeds that reported in year of the corresponding annual report, this may be due to the following reasons:

Tonnage may have been received but not incinerated, i.e. the material is held pending incineration (the operator return to the EA reports as received whereas the annual report focuses on when the waste is incinerated.)
Material may have been received into the site but treated in some other way than incineration.
Material may have been received on the but transferred out of site for disposal/treatment at another site rather than incineration on the site.

EWC Code	Origin of Waste	Tonnes In

Table to display the waste received listed by by region of origin, Incineration Plants

@@ Line 1: / Line 1: @@
 {{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ew_in|where=epr='{{{EPR}}}'|limit=1|data=updated=updated}}{{#vardefine: update|{{#external_value:updated}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ton_in|where=epr='{{{EPR}}}'|data=opt=tin}}{{#vardefine: total| {{#external_value:opt}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ew_in|where=epr='{{{EPR}}}'|data=ewc=ewc,originregion=origin,tin=tin}}
 ==Waste Tonnage, By Origin==
-The table shows a list of the [[Waste]] for the [[WML|Permit]] {{{EPR}}}, that has arrived into sites as reported to the [[Regulator]] and then publicised in their reported statistics. {{#iferror: {{#var:update}}| The Data used is from the most recent returns | The Data was last updated on {{#var:update}}}}. The total reported tonnage arriving at the site was: '''{{#if: {{#var:total}} | {{formatnum: {{#expr: {{#var:total}} round 2}} }}t | 0t }}'''. Where this tonnage exceeds that reported in year of the corresponding annual report, this may be due to the following reasons:
+The table shows a list of the [[Waste]] for the [[WML|Permit]] {{{EPR}}}, that has arrived into sites as reported to the [[Regulator]] and then publicised in their reported statistics. {{#iferror: {{#var:update}}| The Data used is from the most recent returns | The Data was last updated on {{#var:update}}}}. The total reported tonnage arriving at the site was: '''{{#if: {{#var:total}} | {{formatnum: {{#expr: {{#var:total}} round 2}} }}t | 0t }}'''.
+Where this tonnage exceeds that reported in year of the corresponding annual report, this may be due to the following reasons:
 * Tonnage may have been received but not [[incineration|incinerated]], i.e. the material is held pending [[incineration]] (the operator return to the [[EA]] reports as received whereas the annual report focuses on when the waste is incinerated.)
 * Material may have been received into the site but [[treatment|treated]] in some other way than [[incineration]].