query-3f8d1b9bdfd083c3f94cf976cb4a5879

rq turtle/ttl

How to get this query to not time out?I am trying to see a list of all the "Good Articles" of Wikipedia that don't have parallel articles on the Hebrew Wikipedia, but unfortunately whenever I run it, it times out. This is the current query:

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?article ?articleLabel (COUNT(DISTINCT ?sitelink_other) AS ?cnt) 
WHERE {
  # Identify articles that are "Good Articles" on English Wikipedia
  ?sitelink wikibase:badge wd:Q17437798;  # item is a "Good Article"
            schema:about ?article;
            schema:isPartOf <https://en.wikipedia.org/>.

  # Exclude items that have a sitelink to the Hebrew Wikipedia
  MINUS {
    ?sitelink_he schema:about ?article; schema:isPartOf <https://he.wikipedia.org/>.
  }

  # Count the number of interwiki sitelinks
  ?sitelink_other schema:about ?article.

  # Include labels
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?article ?articleLabel 
ORDER BY DESC(?cnt) # order by the count of interwiki sitelinks in descending order

Query found at

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