query-0ee8cc0fcf49e58ac4d2e041115491fe

rq turtle/ttl

Propertiesinstance of (P31)subclass of (P279)located in the administrative territorial entity (P131)phone number (P1329)has use (P366)field of work (P101)

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?hospitalLabel  ?phoneNumberLabel (GROUP_CONCAT(Distinct ?useLabel; separator= ", ") as ?usedFor) 
(GROUP_CONCAT(Distinct ?fieldOfWorkLabel; separator= ", ") as ?field)
WHERE
{
  ?hospital wdt:P31/wdt:P279* wd:Q16917; #hospital             
            wdt:P131 wd:Q1711; #in administrative territory Potsdam
            p:P1329  ?phoneNumberStatement.

  ?phoneNumberStatement pq:P366 ?use;
                        ps:P1329 ?phoneNumber.
  ?use rdfs:label ?useLabel.
  #use rfs:label so it can be used with CONCAT aggregate function
  FILTER(lang(?useLabel) = "en"). 

  #if possible get the field of work
  OPTIONAL{
    ?phoneNumberStatement pq:P101 ?fieldOfWork.
    ?fieldOfWork rdfs:label ?fieldOfWorkLabel.
    FILTER(lang(?fieldOfWorkLabel) = "en").
  }

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

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Hospitals/Report/Potsdam