Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 12:58, 5 July 2022

1,277 bytes added , 2 years ago

→‎Federated querying: mixing data from this Wikibase with data from the NTA in data.bibliotheken.nl (via the PPN)

OlafJanssen

emailconfirmed

952

edits

@@ Line 167: / Line 167: @@
 </sparql>
-=== Federated querying: mixing data from this Wikibase with data from the NTA in data.bibliotheken.nl (via the PPN) ===
+=== Federated querying: mixing data from this Wikibase with data from the NTA in data.bibliotheken.nl (via the PPN) -- TODO!!!!!!!!! ===
 <sparql tryit="1">
-TODO
+# Federated querying: mixing data from this Wikibase with data from the NTA in data.bibliotheken.nl (via the PPN)
+PREFIX wikibase: <http://wikiba.se/ontology#>
+PREFIX kbwdt: <https://kbtestwikibase.wikibase.cloud/prop/direct/>
+PREFIX kbwd: <https://kbtestwikibase.wikibase.cloud/entity/>
+PREFIX wdt: <http://www.wikidata.org/prop/direct/>
+PREFIX wd: <http://www.wikidata.org/entity/>
+PREFIX bd: <http://www.bigdata.com/rdf#>
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
+SELECT DISTINCT ?item ?itemLabel ?itemDescription
+?wikidataEquivalentURI
+?wdImage #P18 image from Wikidata
+?wdWorksInCollection ?wdWorksInCollectionLabelNL
+WHERE
+{
+  VALUES ?item {kbwd:Q10 kbwd:Q29} # Louis Auguste Gustave Doré + Theun de Vries
+  ?item kbwdt:P1 ?wikidataEquivalentURI.
+  #Retrieve some data from data.bibliotheken.nl
+  SERVICE <https://query.wikidata.org/sparql>{
+  OPTIONAL {?wikidataEquivalentURI wdt:P18 ?wdImage.}
+  OPTIONAL {?wikidataEquivalentURI wdt:P6379 ?wdWorksInCollection.
+           ?wdWorksInCollection rdfs:label ?wdWorksInCollectionLabelNL.
+           FILTER(LANG(?wdWorksInCollectionLabelNL) = "nl").}
+ }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
+}
+ORDER BY ASC(xsd:integer(STRAFTER(STR(?item), 'Q')))
 </sparql>