emailconfirmed
952
edits
OlafJanssen (talk | contribs) No edit summary |
OlafJanssen (talk | contribs) |
||
Line 131: | Line 131: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". } | ||
} | } | ||
</sparql> | |||
=== Federated querying: mixing data from this Wikibase with data from Wikidata === | |||
<sparql tryit="1"> | |||
# mixing data from this Wikibase with data from Wikidata | |||
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> |