emailconfirmed
952
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
→Federated querying: mixing data from this Wikibase with data from Wikidata
OlafJanssen (talk | contribs) |
OlafJanssen (talk | contribs) |
||
| Line 142: | Line 142: | ||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | PREFIX wdt: <http://www.wikidata.org/prop/direct/> | ||
PREFIX wd: <http://www.wikidata.org/entity/> | 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 | SELECT DISTINCT ?item ?itemLabel ?itemDescription | ||
?wikidataEquivalentURI | ?wikidataEquivalentURI | ||
?wdImage #P18 image from Wikidata | ?wdImage #P18 image from Wikidata | ||
?wdWorksInCollection ?wdWorksInCollectionLabelNL | |||
WHERE | WHERE | ||
| Line 151: | Line 154: | ||
VALUES ?item {kbwd:Q10 kbwd:Q29} # Louis Auguste Gustave Doré + Theun de Vries | VALUES ?item {kbwd:Q10 kbwd:Q29} # Louis Auguste Gustave Doré + Theun de Vries | ||
?item kbwdt:P1 ?wikidataEquivalentURI. | ?item kbwdt:P1 ?wikidataEquivalentURI. | ||
#Retrieve some data from Wikidata | |||
SERVICE <https://query.wikidata.org/sparql>{ | SERVICE <https://query.wikidata.org/sparql>{ | ||
OPTIONAL {?wikidataEquivalentURI wdt:P18 ?wdImage.} | 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'))) | ORDER BY ASC(xsd:integer(STRAFTER(STR(?item), 'Q'))) | ||
</sparql> | </sparql> | ||