emailconfirmed
952
edits
OlafJanssen (talk | contribs) |
OlafJanssen (talk | contribs) |
||
Line 41: | Line 41: | ||
</sparql> | </sparql> | ||
=== Overview of items (Qs) in this Wikibase, with their Labels, Descriptions and Aliases, both in NL and in EN, as well their equivalent Q-items in Wikidata (if applicable)=== | === Overview of items (Qs) in this Wikibase, with their Labels, Descriptions and Aliases, both in NL and in EN, as well their equivalent Q-items en URIs in Wikidata (if applicable) === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# Overview of items (Qs) in this Wikibase, | # Overview of items (Qs) in this Wikibase, | ||
# with their Labels, Descriptions and Aliases, | # with their Labels, Descriptions and Aliases, | ||
# both in NL and in EN, | # both in NL and in EN, | ||
# as well their equivalent Q-items in Wikidata (if applicable) | # as well their equivalent Q-items en URIs in Wikidata (if applicable) | ||
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | ||
Line 65: | Line 55: | ||
PREFIX wdt: <https://kbtestwikibase.wikibase.cloud/prop/direct/> | PREFIX wdt: <https://kbtestwikibase.wikibase.cloud/prop/direct/> | ||
SELECT ? | SELECT ?item ?itemLabelNL ?itemLabelEN | ||
? | ?itemDescriptionNL ?itemDescriptionEN | ||
? | (GROUP_CONCAT(DISTINCT ?itemAliasNL ; separator = "|") as ?itemAliasesNL ) | ||
(GROUP_CONCAT(DISTINCT ? | (GROUP_CONCAT(DISTINCT ?itemAliasEN ; separator = "|") as ?itemAliasesEN ) | ||
(GROUP_CONCAT(DISTINCT ? | ?wikidataEquivalentURI ?wikidataEquivalentItem | ||
? | |||
WHERE { | WHERE | ||
{ | |||
? | ?item wikibase:identifiers ?b | ||
OPTIONAL{? | OPTIONAL{?item wdt:P1 ?wikidataEquivalentURI.} | ||
OPTIONAL{?item wdt:P4 ?wikidataEquivalentItem.} | |||
OPTIONAL{? | OPTIONAL{?item rdfs:label ?itemLabelNL FILTER(LANG(?itemLabelNL)='nl').} | ||
OPTIONAL{? | OPTIONAL{?item rdfs:label ?itemLabelEN FILTER(LANG(?itemLabelEN)='en').} | ||
OPTIONAL{? | OPTIONAL{?item schema:description ?itemDescriptionNL FILTER(LANG(?itemDescriptionNL) = "nl"). } | ||
OPTIONAL{? | OPTIONAL{?item schema:description ?itemDescriptionEN FILTER(LANG(?itemDescriptionEN) = "en"). } | ||
OPTIONAL{? | OPTIONAL{?item skos:altLabel ?itemAliasNL FILTER(LANG(?itemAliasNL) = "nl"). } | ||
OPTIONAL{? | OPTIONAL{?item skos:altLabel ?itemAliasEN FILTER(LANG(?itemAliasEN) = "en"). } | ||
} | } | ||
GROUP BY ? | GROUP BY ?item ?itemLabelNL ?itemLabelEN ?itemDescriptionNL ?itemDescriptionEN ?wikidataEquivalentURI ?wikidataEquivalentItem | ||
ORDER BY ASC(xsd:integer(STRAFTER(STR(? | ORDER BY ASC(xsd:integer(STRAFTER(STR(?item), 'Q'))) | ||
</sparql> | </sparql> | ||