query-59b1977a844b7f4f1db0f6095a057217
Paintings with no English description but a known artist label
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ("Den" AS ?den) (CONCAT("painting by ", ?creatorLabel) as ?toadd) WHERE {
?item wdt:P31 wd:Q3305213; wdt:P170 ?creator FILTER(?creator != wd:Q4233718) # exclude Anonymous
MINUS {?item wdt:P31 ?other FILTER(?other != wd:Q3305213) } # painting is only type
MINUS {?item schema:description ?engdesc FILTER (lang(?engdesc)="en") } # No English description
?creator rdfs:label ?creatorLabel FILTER (lang(?creatorLabel)="en") # Artist label in English is known
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?creator")
v1("?creatorLabel"):::projected
v6("?den")
v5("?engdesc")
v3("?item"):::projected
v4("?other")
v7("?toadd")
c4(["wd:Q3305213"]):::iri
f0[["?creatorLabel = 'en'"]]
f0 --> v1
f1[["?creator != 'wd:Q4233718'"]]
f1 --> v2
v3 --"wdt:P31"--> c4
v3 --"wdt:P170"--> v2
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
f3[["?other != 'wd:Q3305213'"]]
f3 --> v4
v3 --"wdt:P31"--> v4
end
subgraph minus4["MINUS"]
style minus4 stroke-width:6px,fill:pink,stroke:red;
f5[["?engdesc = 'en'"]]
f5 --> v5
v3 --"schema:description"--> v5
end
v2 --"rdfs:label"--> v1
bind6[/"'Den'"/]
bind6 --as--o v6
bind7[/"concat('painting by ',?creatorLabel)"/]
v1 --o bind7
bind7 --as--o v7