Wikidata:WikiProject Collection highlights National Library of the Netherlands/Admin/SPARQL
Home | Overviews of collection highlights | Reuse | Publications, presentations etc | How you can help us | Project administration |
Project list | Data overview tables | Data dashboards | Datamodels & SHex | Admin SPARQL queries | Project statistics | All project pages |
SPARQL queries
edit#articles about KB collection highlights on Dutch Wikipedia
select ?item ?itemLabel ?_articleNL where {
?item p:P195 ?st .
?st ps:P195 wd:Q1526131 .
?st pq:P2868 wd:Q29188408 .
OPTIONAL {
?_articleNL schema:about ?item.
?_articleNL schema:isPartOf <https://nl.wikipedia.org/>.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,nl". }
}
#articles about KB collection highlights in other language (i.e. not NL) wikipedias
select ?item ?itemLabel ?_articleDE where {
?item p:P195 ?st .
?st ps:P195 wd:Q1526131 .
?st pq:P2868 wd:Q29188408 .
OPTIONAL {
?_articleDE schema:about ?item.
?_articleDE schema:isPartOf <https://de.wikipedia.org/>.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,nl". }
}
#Getting all properties of KB collection highlights
#https://stackoverflow.com/questions/42076194/get-properties-from-a-group-of-items-in-with-sparql
SELECT DISTINCT ?property ?propLabel WHERE {
?item p:P195 ?st .
?st ps:P195 wd:Q1526131;pq:P2868 wd:Q29188408.
?item ?property [].
?prop wikibase:directClaim ?property .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?property