query-02202daeee586db461ff13f5ed05320c
Top 1000 categories available on most wikis, but not on Central Kurdish Wikipedia https://w.wiki/BKZJ@wikidata is the original author of the first version of this query. See: User:TomT0mCredit: w:ckb:ویکیپیدیا:ڕاپۆرتی بنکەدراوە/پۆلە گرنگە دروست نەکراوەکانThis is really useful for small (and mid-sized) wikis to get started. See
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 schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?enLabel ?numOfSitelinks {
?item wdt:P31 wd:Q4167836 .
?item wikibase:sitelinks ?numOfSitelinks .
?item rdfs:label ?enLabel.
filter(lang(?enLabel) = "en")
filter (?numOfSitelinks > 70)
MINUS {
?cat schema:isPartOf <https://ckb.wikipedia.org/> ;
schema:about ?item .
}
} ORDER BY DESC(?numOfSitelinks) LIMIT 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?cat")
v2("?enLabel"):::projected
v3("?item"):::projected
v1("?numOfSitelinks"):::projected
c8([https://ckb.wikipedia.org/]):::iri
c4(["wd:Q4167836"]):::iri
f0[["?numOfSitelinks > '70^^xsd:integer'"]]
f0 --> v1
f1[["?enLabel = 'en'"]]
f1 --> v2
v3 --"wdt:P31"--> c4
v3 --"wikibase:sitelinks"--> v1
v3 --"rdfs:label"--> v2
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v4 --"schema:isPartOf"--> c8
v4 --"schema:about"--> v3
end