query-3f4a46f2cf7defb1206ce3b9f071b64b
Things in the Ashmolean that have gold as their only materialShould give no results (no results as of 19 May 2019)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item ?url WHERE {
?item wdt:P195 wd:Q636400; # collection: Ashmolean
wdt:P31 wd:Q3305213; # type: painting
wdt:P186 wd:Q897 # material: gold
MINUS {?item wdt:P186 ?mat FILTER (?mat != wd:Q897) } # no non-gold material
OPTIONAL {?item wdt:P973 ?url}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
v2("?mat")
v3("?url"):::projected
c6(["wd:Q897"]):::iri
c4(["wd:Q3305213"]):::iri
c2(["wd:Q636400"]):::iri
v1 --"wdt:P195"--> c2
v1 --"wdt:P31"--> c4
v1 --"wdt:P186"--> c6
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
f1[["?mat != 'wd:Q897'"]]
f1 --> v2
v1 --"wdt:P186"--> v2
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P973".-> v3
end