Key Metric Rankings: Difference between revisions

Line 7:

==England==

{{#get_db_data: db=ID |from=england_joined|~~where~~=year=~~'2020-21'~~|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}

{{#get_db_data: db=ID| from=england_joined|limit=1|data=year=year}}

For reporting period: {{#external_value:year}}

{{#get_db_data: db=ID |from=england_joined|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}

{| class="wikitable sortable"

! Authority

! Recycling (%)

Line 28:

==Scotland==

{{#get_db_data: db=ID| from=scotland_joined|limit=1|data=period=period}}

For reporting period: {{#external_value:period}}{{#clear_external_data:}}

{{#get_db_data: db=ID |from=scotland_joined |data=authority=authority,mrroprtpc=mrroprtpc,rnkrec=rnkrec,ghhgkgpp=ghhgkgpp,rnkkgpp=rnkkgpp,tco2epp=tco2epp,rnkcarb=rnkcarb}}

{| class="wikitable sortable"

! Authority

! Recycling (%)

Line 54:

Line 52:

==Wales==

{{#get_db_data: db=ID| from=wales_joined |limit=1|data=period=period}}

For reporting period: {{#external_value:period}}{{#clear_external_data:}}

{{#get_db_data: db=ID |from=wales_joined |data=authority=authority,wrrccpc=wrrccpc,rnkkkwrec=rnkkkwrec,hhwpp=hhwpp,rnkhhwpp=rnkhhwpp}}

{| class="wikitable sortable"

! Authority

! Recycling (%)

@@ Line 7: / Line 7: @@
 <br clear=all />
 ==England==
 {{#clear_external_data:}}
-{{#get_db_data: db=ID |from=england_joined|where=year='2020-21'|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}
+{{#get_db_data: db=ID| from=england_joined|limit=1|data=year=year}}
+For reporting period: {{#external_value:year}}
+{{#clear_external_data:}}
+{{#get_db_data: db=ID |from=england_joined|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}
 {| class="wikitable sortable"
 ! Authority
 ! Recycling (%)
@@ Line 28: / Line 28: @@
 ==Scotland==
 {{#clear_external_data:}}
+{{#get_db_data: db=ID| from=scotland_joined|limit=1|data=period=period}}
+For reporting period: {{#external_value:period}}{{#clear_external_data:}}
 {{#get_db_data: db=ID |from=scotland_joined |data=authority=authority,mrroprtpc=mrroprtpc,rnkrec=rnkrec,ghhgkgpp=ghhgkgpp,rnkkgpp=rnkkgpp,tco2epp=tco2epp,rnkcarb=rnkcarb}}
 {| class="wikitable sortable"
 ! Authority
 ! Recycling (%)
@@ Line 54: / Line 52: @@
 ==Wales==
 {{#clear_external_data:}}
+{{#get_db_data: db=ID| from=wales_joined |limit=1|data=period=period}}
+For reporting period: {{#external_value:period}}{{#clear_external_data:}}
 {{#get_db_data: db=ID |from=wales_joined |data=authority=authority,wrrccpc=wrrccpc,rnkkkwrec=rnkkkwrec,hhwpp=hhwpp,rnkhhwpp=rnkhhwpp}}
 {| class="wikitable sortable"
 ! Authority
 ! Recycling (%)