query-75c46a3e0f64eae7b6f1f8945e22c92d

rq turtle/ttl

Barchart top Swedish municipals regarding nr outdoor gyms

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Top Swedish municipals regarding nr outdoor gyms 
#defaultView:BarChart
SELECT ?adminItem ?adminItemLabel (count(?item) as ?nr) WHERE {
    ?item wdt:P6104 wd:Q107186275;
      wdt:P131 ?adminItem;
      wdt:P17 wd:Q34.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
} group by ?adminItem ?adminItemLabel
order by desc(?nr) limit 50

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?adminItem"):::projected v2("?item"):::projected v4("?nr") c7(["bd:serviceParam"]):::iri c9(["sv,en"]):::literal c2(["wd:Q107186275"]):::iri c5(["wd:Q34"]):::iri v2 --"wdt:P6104"--> c2 v2 --"wdt:P131"--> v3 v2 --"wdt:P17"--> c5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end bind1[/"count(?item)"/] v2 --o bind1 bind1 --as--o v4