query-c75b130f71099ad5b69b860262c63d5f

rq turtle/ttl

Propertiesheadquarters location (P159)contains the administrative territorial entity (P150)located in the administrative territorial entity (P131)instance of (P31)

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 ?item ?itemLabel ?liegtinLabel ?isteinLabel
WHERE {
  ?item wdt:P159 ?sub0. # P159 = Hauptverwaltung
  ?tree0 wdt:P150* ?sub0. # P150 = Untereinheit
  ?tree0 wdt:P131* wd:Q1197. # P131 = liegt in der Verwaltungseinheit
  ?item wdt:P131 ?liegtin.
  ?item wdt:P31 ?istein.
   SERVICE wikibase:label {
     bd:serviceParam wikibase:language "de,en" .
   }
}
LIMIT 50

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?istein") v1("?item"):::projected v4("?liegtin") v2("?sub0") v3("?tree0") c7(["bd:serviceParam"]):::iri c4(["wd:Q1197"]):::iri c9(["de,en"]):::literal v1 --"wdt:P159"--> v2 v3 --"wdt:P150"--> v2 v3 --"wdt:P131"--> c4 v1 --"wdt:P131"--> v4 v1 --"wdt:P31"--> v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end