query-140c60b2d3c6860d231192fe6c918d14

rq turtle/ttl

Propertiesinstance of (P31)subclass of (P279)located in the administrative territorial entity (P131)affiliation (P1416)

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 ?hospitalLabel  ?affiliation ?affiliationLabel
WHERE
{
  ?hospital wdt:P31/wdt:P279* wd:Q16917; #hospital          
            wdt:P131 wd:Q1711; #Potsdam
            wdt:P1416 ?affiliation.
  ?affiliation wdt:P279* wd:Q9174.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?hospitalLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?affiliation"):::projected v2("?hospital") v1("?hospitalLabel"):::projected a1((" ")) c5(["wd:Q1711"]):::iri c9(["bd:serviceParam"]):::iri c7(["wd:Q9174"]):::iri c3(["wd:Q16917"]):::iri c11(["en"]):::literal v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v2 --"wdt:P131"--> c5 v2 --"wdt:P1416"--> v3 v3 --"wdt:P279"--> c7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end