Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 12:48, 30 June 2022

1,543 bytes added , 1 year ago

→‎Alle Qs in deze Wikibase

OlafJanssen

emailconfirmed

952

edits

@@ Line 41: / Line 41: @@
 </sparql>
-=== Alle Qs in deze Wikibase===
+=== 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">
@@ Line 53: / Line 53: @@
 }
 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>