query-cff738e6128f972d3615ec7e90db1d49
select Australian women have an enwiki article with an image
but have no image on wikidata
SELECT ?item ?itemLabel ?article ?sitelink WHERE { { ?item wdt:P21 wd:Q6581072. # is a women ?item wdt:P27 wd:Q408. # Is Australian ?sitelink ^schema:name ?article . ?article schema:about ?item ; schema:isPartOf https://en.wikipedia.org/ . } MINUS { ?item wdt:P18 ?image.} { SERVICE wikibase:mwapi { bd:serviceParam wikibase:api "Search" . bd:serviceParam wikibase:endpoint "en.wikipedia.org" . bd:serviceParam mwapi:srnamespace "0" . bd:serviceParam mwapi:srlimit "max" . bd:serviceParam mwapi:srwhat "text" . bd:serviceParam mwapi:srsearch 'insource:"image = "' . ?title wikibase:apiOutput mwapi:title . } BIND (STRLANG(?title, "en") as ?sitelink) } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } LIMIT 100
Use at
- https://query.wikidata.org/sparql
PREFIX mwapi: <http://wikiba.se/ontology#>
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 Australian women have an enwiki article with an image
# but have no image on wikidata
SELECT ?item ?itemLabel ?article ?sitelink
WHERE
{
{
?item wdt:P21 wd:Q6581072. # is a women
?item wdt:P27 wd:Q408. # Is Australian
?sitelink ^schema:name ?article .
?article schema:about ?item ;
schema:isPartOf <https://en.wikipedia.org/> .
}
MINUS { ?item wdt:P18 ?image.}
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:api "Search" .
bd:serviceParam wikibase:endpoint "en.wikipedia.org" .
bd:serviceParam mwapi:srnamespace "0" .
bd:serviceParam mwapi:srlimit "max" .
bd:serviceParam mwapi:srwhat "text" .
bd:serviceParam mwapi:srsearch 'insource:"image = "' .
?title wikibase:apiOutput mwapi:title .
}
BIND (STRLANG(?title, "en") as ?sitelink)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 100