query-e4d8bb2a18def4ec402f957c2d4a4eb9
Painting to find the paintings that are in the SNK collection, but no link to herkomstgezocht.nl. Something fishy going on! SELECT DISTINCT ?item ?itemLabel ?url WHERE { ?item wdt:P195 wd:Q28045665 . ?item wdt:P31 wd:Q3305213 . ?item wdt:P973 ?url MINUS { ?item wdt:P973 ?filterurl FILTER regex (STR(?filterurl), "^http://herkomstgezocht.nl/nl/nk-collectie/.*"). } SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". } } LIMIT 50
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#>
# Painting to find the paintings that are in the SNK collection, but no link to herkomstgezocht.nl. Something fishy going on!
SELECT DISTINCT ?item ?itemLabel ?url WHERE {
?item wdt:P195 wd:Q28045665 .
?item wdt:P31 wd:Q3305213 .
?item wdt:P973 ?url
MINUS {
?item wdt:P973 ?filterurl
FILTER regex (STR(?filterurl), "^http://herkomstgezocht.nl/nl/nk-collectie/.*"). }
SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
}
LIMIT 50
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?filterurl")
v1("?item"):::projected
v2("?url"):::projected
c4(["wd:Q3305213"]):::iri
c8(["bd:serviceParam"]):::iri
c2(["wd:Q28045665"]):::iri
c10(["nl"]):::literal
v1 --"wdt:P195"--> c2
v1 --"wdt:P31"--> c4
v1 --"wdt:P973"--> v2
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
f1[["regex(str(?filterurl),'^http://herkomstgezocht.nl/nl/nk-collectie/.*')"]]
f1 --> v3
v1 --"wdt:P973"--> v3
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end