query-ec2dc9d7fd83aa7cf16130e99f8d4db1

rq turtle/ttl

Propertiesinstance of (P31)sex or gender (P21)country of citizenship (P27)

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 bd: <http://www.bigdata.com/rdf#>
PREFIX schema: <http://schema.org/>
PREFIX hint: <http://www.bigdata.com/queryHints#>

SELECT ?item ?itemLabel ?itemDescription (COUNT(DISTINCT ?article) AS ?count) WHERE {
  {
    SELECT ?item WHERE {
      {
        hint:Query hint:optimizer "None".
        ?item wdt:P31 wd:Q5. # all humans
        ?item wdt:P21 wd:Q6581072.
        ?item wdt:P27 wd:Q668.
        MINUS {
          ?sitelinkhy schema:about ?item.
          ?sitelinkhy schema:isPartOf <https://or.wikipedia.org/>.
        }
      }
      ?article schema:about ?item.
      { ?article schema:isPartOf <https://en.wikipedia.org/>. }
    }
  }
  ?article schema:about ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?item ?itemLabel ?itemDescription
ORDER BY DESC(?count)
LIMIT 123

Query found at

• https://www.wikidata.org/wiki/User:MKar/Query