query-e5bb3b699f02e6e669722edb040d2f8c

rq turtle/ttl

SPARQL

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT
?item ?itemLabel 
(GROUP_CONCAT(DISTINCT ?langP407 ; separator = " XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ") as ?langOfWork)
(GROUP_CONCAT(DISTINCT ?DatURL ; separator = " XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ") as ?DescAtURL)
(GROUP_CONCAT(DISTINCT ?DatURL_language ; separator = " XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ") as ?langOfReferenceSource)
(GROUP_CONCAT(DISTINCT ?DatURL_reference_url ; separator = " XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ") as ?DescAtURL_reference_url)
(GROUP_CONCAT(DISTINCT ?DatURL_stated_in ; separator = " XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ") as ?DescAtURL_stated_in)
(GROUP_CONCAT(DISTINCT ?DatURL_retrieved ; separator = " XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ") as ?DescAtURL_retrieved)
WHERE {
  ?item p:P195 ?st .
  ?st  ps:P195 wd:Q1526131 .
  ?st pq:P2868 wd:Q29188408
  OPTIONAL {?item wdt:P973 ?DatURL.}
  OPTIONAL {?item wdt:P407 ?langP407.}  
  OPTIONAL {?item p:P973 [prov:wasDerivedFrom [pr:P854 ?DatURL_reference_url]] .} 
  OPTIONAL {?item p:P973 [pq:P407 ?DatURL_language].} 
  OPTIONAL {?item p:P973 [prov:wasDerivedFrom [pr:P248 ?DatURL_stated_in]] .} 
  OPTIONAL {?item p:P973 [prov:wasDerivedFrom [pr:P813 ?DatURL_retrieved]] .} 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
} 
GROUP BY ?item ?itemLabel 
ORDER BY ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?DatURL"):::projected v7("?DatURL_language"):::projected v6("?DatURL_reference_url"):::projected v9("?DatURL_retrieved"):::projected v8("?DatURL_stated_in"):::projected v11("?DescAtURL") v13("?DescAtURL_reference_url") v15("?DescAtURL_retrieved") v14("?DescAtURL_stated_in") v2("?item"):::projected v1("?itemLabel"):::projected v12("?langOfReferenceSource") v10("?langOfWork") v5("?langP407"):::projected v3("?st") a2((" ")) a1((" ")) a3((" ")) a5((" ")) a4((" ")) a7((" ")) a6((" ")) c3(["wd:Q1526131"]):::iri c15(["bd:serviceParam"]):::iri c5(["wd:Q29188408"]):::iri c17(["nl"]):::literal v2 --"p:P195"--> v3 v3 --"p:statement/P195"--> c3 v3 --"p:qualifier/P2868"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P973".-> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P407".-> v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; a1 -."p:reference/P854".-> v6 a2 --"prov:wasDerivedFrom"--> a1 v2 --"p:P973"--> a2 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; a3 -."p:qualifier/P407".-> v7 v2 --"p:P973"--> a3 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; a4 -."p:reference/P248".-> v8 a5 --"prov:wasDerivedFrom"--> a4 v2 --"p:P973"--> a5 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; a6 -."p:reference/P813".-> v9 a7 --"prov:wasDerivedFrom"--> a6 v2 --"p:P973"--> a7 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end bind6[/"?langP407"/] v5 --o bind6 bind6 --as--o v10 bind7[/"?DatURL"/] v4 --o bind7 bind7 --as--o v11 bind8[/"?DatURL_language"/] v7 --o bind8 bind8 --as--o v12 bind9[/"?DatURL_reference_url"/] v6 --o bind9 bind9 --as--o v13 bind10[/"?DatURL_stated_in"/] v8 --o bind10 bind10 --as--o v14 bind11[/"?DatURL_retrieved"/] v9 --o bind11 bind11 --as--o v15