query-8598e5476e36b6d3cea43b87ed02e170

rq turtle/ttl

RemovalsLokale Umzüge über Gewerbebetrieb (aufsteigend)

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#>
SELECT DISTINCT ?company ?companyLabel (COUNT(?addr) AS ?addressCount) WHERE {
  ?company (wdt:P31/(wdt:P279*)) wd:Q4830453;
    (wdt:P2868/(wdt:P279*)) wd:Q19287329;
    wdt:P159 wd:Q64;
    wdt:P6375 ?addr.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
GROUP BY ?company ?companyLabel
ORDER BY DESC (?addressCount)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?addr"):::projected v4("?addressCount") v2("?company"):::projected a1((" ")) a2((" ")) c12(["de"]):::literal c10(["bd:serviceParam"]):::iri c5(["wd:Q19287329"]):::iri c3(["wd:Q4830453"]):::iri c7(["wd:Q64"]):::iri v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v2 --"wdt:P2868"--> a2 a2 --"wdt:P279"--> c5 v2 --"wdt:P159"--> c7 v2 --"wdt:P6375"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end bind1[/"count(?addr)"/] v3 --o bind1 bind1 --as--o v4