Untitled query #47673

SQL

PREFIX schema: <http://schema.org/>

SELECT ?item ?enarticle ?linkcount ?itemLabel WHERE {
  {
    SELECT ?item ?enarticle (COUNT(DISTINCT ?sitelink) AS ?linkcount) WHERE {
      ?item (wdt:P31/wdt:P279) wd:Q215627.
      ?sitelink schema:about ?item.
       ?item wdt:P17 wd:Q1028.
      OPTIONAL {
        ?enarticle schema:about ?item.
        ?enarticle schema:isPartOf <https://en.wikipedia.org/>.
      }
      MINUS {
        ?article schema:about ?item.
        ?article schema:inLanguage "fa".
        ?article schema:isPartOf <https://fa.wikipedia.org/>.
      }
    }
    GROUP BY ?item ?itemLabel ?enarticle
    ORDER BY DESC(?linkcount)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fa". }
}
LIMIT 2000
SQL

Checking query status...
