query-a34bc958e61c05a3c19378c4e536a095

rq turtle/ttl

speciesCan I have species with the most sitelinks yet not in English Wikipedia? 21:42, 1 July 2023 (UTC) 115.188.159.19005:32, 20 July 2023 (UTC) 115.188.159.190 (P141)IUCN conservation status : would it work if it only includes species with a MartinPoulter@ 16:12, 3 July 2023 (UTC)) talk (MartinPoulterHere's a query that should do what you ask, but unfortunately it times out as Wikidata knows about so many species. Many someone else here can work out how to get it to finish?

Use at

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/>
SELECT ?item ?links WHERE {
  ?item wdt:P105 wd:Q7432 . # Taxon rank "species"
  MINUS{?enwp schema:about ?item; schema:isPartOf <https://en.wikipedia.org/>} # not on English Wikipedia
  ?item wikibase:sitelinks ?links # count sitelinks
} ORDER BY DESC(?links) LIMIT 50

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?enwp") v2("?item"):::projected v1("?links"):::projected c5([https://en.wikipedia.org/]):::iri c2(["wd:Q7432"]):::iri v2 --"wdt:P105"--> c2 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v3 --"schema:about"--> v2 v3 --"schema:isPartOf"--> c5 end v2 --"wikibase:sitelinks"--> v1