query-e69c5c11b3fc10f689cb343369d5d0cb
paintings who's author died more than 100 years ago
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT DISTINCT ?item (YEAR(?dod) as ?year)
WHERE {
?item wdt:P31 wd:Q3305213 .
MINUS { ?item wdt:P6216 [] } .
?item wdt:P170/wdt:P570 ?dod .
FILTER(YEAR(?dod) < 1918)
}
Limit 20000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?dod"):::projected
v2("?item"):::projected
v3("?year")
a1((" "))
a2((" "))
c3(["wd:Q3305213"]):::iri
f0[["year-from-dateTime(?dod) < '1918^^xsd:integer'"]]
f0 --> v1
v2 --"wdt:P31"--> c3
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P6216"--> a1
end
v2 --"wdt:P170"--> a2
a2 --"wdt:P570"--> v1
bind2[/"year-from-dateTime(?dod)"/]
v1 --o bind2
bind2 --as--o v3