emailconfirmed
952
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
→aaaaaa
OlafJanssen (talk | contribs) Tag: Manual revert |
OlafJanssen (talk | contribs) (→aaaaaa) |
||
| Line 1: | Line 1: | ||
== aaaaaa == | == aaaaaa == | ||
=== bbb === | === bbb === | ||
<sparql tryit="1"> | |||
# Overview of properties in this Wikibase, | |||
# with their Labels, Descriptions and Aliases, | |||
# both in NL and in EN, | |||
# as well their equivalent properties 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 DISTINCT ?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> | |||
==Voorbeelden== | ==Voorbeelden== | ||