query-9152f0f35dca03b8b1406056ad60beb3
National economy indicators: set most recent value as preferredproperties with more than one statement Sample country )?count(DESC ORDER BY )1 > ?count( HAVING ?pLabel ?p GROUP BY } } ."[AUTO_LANGUAGE],en" language:wikibase serviceParam:bd { label:wikibase SERVICE . ?wdt directClaim:wikibase ?p . ?v ?wdt Q1025:wd { )?count as )*(COUNT( ?pLabel ?p SELECT Properties to change
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?p ?pLabel (COUNT(*) as ?count) (COUNT(DISTINCT ?place) as ?ct_places)
{
VALUES ?wdt { wdt:P2132 wdt:P2134 wdt:P2299 wdt:P4010 wdt:P1279 }
?place ?wdt ?v .
?p wikibase:directClaim ?wdt .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?p ?pLabel
ORDER BY DESC(?count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?count")
v6("?ct_places")
v5("?p"):::projected
v3("?place"):::projected
v4("?v")
v2("?wdt")
c3(["bd:serviceParam"]):::iri
c5(["#91;AUTO_LANGUAGE#93;,en"]):::literal
bind0[/VALUES ?wdt/]
bind0-->v2
bind00(["wdt:P2132"])
bind00 --> bind0
bind01(["wdt:P2134"])
bind01 --> bind0
bind02(["wdt:P2299"])
bind02 --> bind0
bind03(["wdt:P4010"])
bind03 --> bind0
bind04(["wdt:P1279"])
bind04 --> bind0
v3 -->v2--> v4
v5 --"wikibase:directClaim"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c3 --"wikibase:language"--> c5
end
bind3[/"count(*)"/]
bind3 --as--o v6
bind4[/"count(?place)"/]
v3 --o bind4
bind4 --as--o v6