query-9041627245eabfbdb27792d8de183d94
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select distinct ?item ?situation ?unitLabel where {
?item wdt:P31 wd:Q5 ;
wdt:P21 wd:Q6581072 ;
p:P2218 ?s .
?s rdf:type wikibase:BestRank .
?s psv:P2218 ?psvs .
?psvs wikibase:quantityAmount ?situation.
?psvs wikibase:quantityUnit ?unit.
filter (?situation >= 1000000000)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
order by desc (?situation)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v4("?psvs")
v3("?s")
v1("?situation"):::projected
v5("?unit")
c8(["wikibase:BestRank"]):::iri
c5(["wd:Q6581072"]):::iri
c13(["bd:serviceParam"]):::iri
c3(["wd:Q5"]):::iri
c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["?situation >= '1000000000^^xsd:integer'"]]
f0 --> v1
v2 --"p:direct/P31"--> c3
v2 --"p:direct/P21"--> c5
v2 --"p:P2218"--> v3
v3 --"a"--> c8
v3 --"p:statement/value/P2218"--> v4
v4 --"wikibase:quantityAmount"--> v1
v4 --"wikibase:quantityUnit"--> v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end