emailconfirmed
952
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
→Alle Qs in deze Wikibase
OlafJanssen (talk | contribs) No edit summary |
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)=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
| Line 53: | Line 53: | ||
} | } | ||
ORDER BY ASC(xsd:integer(STRAFTER(STR(?identifier), 'Q'))) | ORDER BY ASC(xsd:integer(STRAFTER(STR(?identifier), 'Q'))) | ||
# 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) | |||
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | |||
PREFIX schema: <http://schema.org/> | |||
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |||
PREFIX wikibase: <http://wikiba.se/ontology#> | |||
PREFIX wdt: <https://kbtestwikibase.wikibase.cloud/prop/direct/> | |||
SELECT ?p ?pType | |||
?pLabelNL ?pLabelEN | |||
?pDescriptionNL ?pDescriptionEN | |||
(GROUP_CONCAT(DISTINCT ?pAliasNL ; separator = "|") as ?pAliasesNL ) | |||
(GROUP_CONCAT(DISTINCT ?pAliasEN ; separator = "|") as ?pAliasesEN ) | |||
?wikidataEquivalentProperty | |||
WHERE { | |||
?p wikibase:propertyType ?pType . | |||
OPTIONAL{?p wdt:P1 ?wikidataEquivalentProperty.} | |||
OPTIONAL{?p rdfs:label ?pLabelNL FILTER(LANG(?pLabelNL)='nl').} | |||
OPTIONAL{?p rdfs:label ?pLabelEN FILTER(LANG(?pLabelEN)='en').} | |||
OPTIONAL{?p schema:description ?pDescriptionNL FILTER(LANG(?pDescriptionNL) = "nl"). } | |||
OPTIONAL{?p schema:description ?pDescriptionEN FILTER(LANG(?pDescriptionEN) = "en"). } | |||
OPTIONAL{?p skos:altLabel ?pAliasNL FILTER(LANG(?pAliasNL) = "nl"). } | |||
OPTIONAL{?p skos:altLabel ?pAliasEN FILTER(LANG(?pAliasEN) = "en"). } | |||
} | |||
GROUP BY ?p ?pType ?pLabelNL ?pLabelEN ?pDescriptionNL ?pDescriptionEN ?wikidataEquivalentProperty | |||
ORDER BY ASC(xsd:integer(STRAFTER(STR(?p), 'P'))) | |||
</sparql> | </sparql> | ||