emailconfirmed
952
edits
Project:SPARQL/examples: Difference between revisions
→Federated querying: mixing data from this Wikibase with data from Wikidata
OlafJanssen (talk | contribs) |
OlafJanssen (talk | contribs) |
||
| Line 137: | Line 137: | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Federated querying: mixing data from this Wikibase with data from Wikidata | # Federated querying: mixing data from this Wikibase with data from Wikidata | ||
PREFIX wikibase: <http://wikiba.se/ontology#> | PREFIX wikibase: <http://wikiba.se/ontology#> | ||
PREFIX | 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/> | |||
SELECT ?item ?itemLabel ?itemDescription | SELECT DISTINCT ?item ?itemLabel ?itemDescription | ||
?wikidataEquivalentURI | ?wikidataEquivalentURI | ||
?wdImage #P18 image from Wikidata | |||
WHERE | WHERE | ||
{ | { | ||
?item | VALUES ?item {kbwd:Q10 kbwd:Q29} # Louis Auguste Gustave Doré + Theun de Vries | ||
?item | ?item kbwdt:P1 ?wikidataEquivalentURI. | ||
SERVICE <https://query.wikidata.org/sparql>{ | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". } | OPTIONAL {?wikidataEquivalentURI wdt:P18 ?wdImage.} | ||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". } | |||
} | } | ||
ORDER BY ASC(xsd:integer(STRAFTER(STR(?item), 'Q'))) | ORDER BY ASC(xsd:integer(STRAFTER(STR(?item), 'Q'))) | ||
</sparql> | </sparql> | ||