query-78518aa63bbe562e5b4fb7d89f65facd

rq turtle/ttl

Women without image, from a particular country, ordered by the number of Wikimedia projects in which they appear SELECT ?woman ?womanLabel ?linkcount WHERE { ?woman wdt:P31 wd:Q5 ; # Instance of human being... wdt:P21 wd:Q6581072 . # ...whose sex or gender is female. ?woman wikibase:sitelinks ?linkcount . # Count the number of sitelinks to different Wikipedias and other projects. { ?woman wdt:P19/wdt:P131* wd:Q77 . } # The woman was born in Uruguay or in a place located in the administrative territorial entity of Uruguay... UNION # ...or... { ?woman wdt:P27 wd:Q77 . } # ...her country of citizenship is Uruguay. MINUS { ?woman wdt:P18 ?image # Exclude if she has an image in her Wikidata item. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?woman ?womanLabel ?linkcount # Group to avoid duplicate results. ORDER BY DESC(?linkcount) # Order by descending number of sitelinks. More sitelinks suggest more relevance.

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#>
# Women without image, from a particular country, ordered by the number of Wikimedia projects in which they appear
SELECT ?woman ?womanLabel ?linkcount
WHERE
{
  ?woman wdt:P31 wd:Q5 ;   # Instance of human being...
         wdt:P21 wd:Q6581072 .  # ...whose sex or gender is female.
  ?woman wikibase:sitelinks ?linkcount .  # Count the number of sitelinks to different Wikipedias and other projects.
  { ?woman wdt:P19/wdt:P131* wd:Q77 . }  # The woman was born in Uruguay or in a place located in the administrative territorial entity of Uruguay...
  UNION  # ...or...
  { ?woman wdt:P27 wd:Q77 . }  # ...her country of citizenship is Uruguay.
  MINUS {
  ?woman wdt:P18 ?image  # Exclude if she has an image in her Wikidata item.
  } 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?woman ?womanLabel ?linkcount  # Group to avoid duplicate results.
ORDER BY DESC(?linkcount)  # Order by descending number of sitelinks. More sitelinks suggest more relevance.

Query found at

• https://www.wikidata.org/wiki/User:Pepe_piton/Queries