Kullanıcı:Chidgk1/deneme tahtası: Revizyonlar arasındaki fark
İçerik silindi İçerik eklendi
Değişiklik özeti yok |
Değişiklik özeti yok |
||
1. satır:
{{Wikidata list
|sparql=SELECT DISTINCT ?item ?
WHERE
{
Satır 9 ⟶ 6:
?item wdt:P17 wd:Q43 . # ?item is in Turkey
?item wdt:P5817 wd:Q55654238 . # ?item state of use is "in use"
?item wdt:P2109 ?InstalledCapacity . # write property as name so easier to follow code below
FILTER (?InstalledCapacity >= 40) . # Only list plants of 40 MW or over installed capacity
optional {?
?
?stat20 pq:CapacityPayment ?year20▼
filter(year(?year21)=2021) }
optional {?item p:P5991 ?g20 .
?g20 ps:P5991 ?ghg2020 .
filter(year(?year20)=2020) }
▲ optional {?item p:P4131 ?stat21 . # To add another year duplicate these 4 lines and add one to all the year numbers. Also add the column below.
optional {?item p:P9274 ?s21 . # Capacity payment by year
▲ ?stat21 ps:P4131 ?2021 . # And add the data to Wikidata of course - if you could automate adding the data please document how.
?s21 ps:P9274 ?sub2021 . # To add another year copy these 4 lines, paste them above and add one to all the year numbers. Also add the column below.
?stat21 pq:P585 ?year21▼
?s21 pq:P585 ?year21 # And add the data to Wikidata of course - if you could automate adding the data please document how.
filter(year(?year21)=2021) }
optional {?item p:P9274 ?s20 .
?s20 ps:P9274 ?sub2020 .
filter(year(?year20)=2020) }
}
|columns=label:Santral,P2109
|section=
|min_section=
|