query-5018418bdf19c21c2925714946622db1

rq turtle/ttl

How to get all the items in the results of this query to be sorted by the amount of interwiki links (sitelinks)Does anyone know why this query does not sort the results by the amount of interwiki links each article has? (the top item on this list says that the CNT=585 while in reality it is 38)

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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 bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?movie ?movieLabel (COUNT(?sitelink) AS ?cnt) 
WHERE {
  ?movie wdt:P31 wd:Q11424. # item is a film
  ?movie wdt:P577 ?release_date. # item has a publication date (release date)
  FILTER (?release_date >= "1980-01-01T00:00:00Z"^^xsd:dateTime && ?release_date < "1990-01-01T00:00:00Z"^^xsd:dateTime) # filter by date range
  ?sitelink schema:about ?movie.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  MINUS {
    _:article schema:about ?movie; schema:isPartOf <https://he.wikipedia.org/>. # exclude items with an article on hewiki
  }
}
GROUP BY ?movie ?movieLabel 
ORDER BY DESC(?cnt) # order by the count of sitelinks in descending order

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2024/08