query-1618e4526c662c20b6569370b8b2b43d
100 most significant items missing labels in Twi
(change the "tw" below to another language code to get the same query for another language)
SELECT ?item ?sitelinks WHERE { ?item wikibase:sitelinks ?sitelinks. hint:Prior hint:rangeSafe true. FILTER(?sitelinks >= 100) # use at-least-100-sitelinks as an indicator of significance
MINUS { ?item wdt:P31/wdt:P279* wd:Q58494026} # exclude Wikimedia internal items (categories, templates, etc.)
MINUS { ?item rdfs:label ?label FILTER(LANG(?label) = "tw") } # <-- change language here
} ORDER BY DESC(?sitelinks) LIMIT 100
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
# 100 most significant items missing labels in Twi
# (change the "tw" below to another language code to get the same query for another language)
SELECT ?item ?sitelinks WHERE {
?item wikibase:sitelinks ?sitelinks.
FILTER(?sitelinks >= 100) # use at-least-100-sitelinks as an indicator of significance
MINUS { ?item wdt:P31/wdt:P279* wd:Q58494026} # exclude Wikimedia internal items (categories, templates, etc.)
MINUS { ?item rdfs:label ?label FILTER(LANG(?label) = "tw") } # <-- change language here
} ORDER BY DESC(?sitelinks)
LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v3("?label")
v1("?sitelinks"):::projected
a1((" "))
c5(["wd:Q58494026"]):::iri
f0[["?sitelinks >= '100^^xsd:integer'"]]
f0 --> v1
v2 --"wikibase:sitelinks"--> v1
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c5
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
f3[["?label = 'tw'"]]
f3 --> v3
v2 --"rdfs:label"--> v3
end