query-9dfd96a893d4f5f046c6b5d62a7ecd9e
by CamelCaseNick select (replace(str(?stolperstein), str(wd:), "") as ?qid) (replace(str(?commemorated), str(wd:), "") as ?P547) (replace(str(?commemorated), str(wd:), "") as ?S3452) where { ?stolperstein wdt:P31 wd:Q26703203; wdt:P18 ?image. ?commemorated wdt:P31 wd:Q5; wdt:P1801 ?image. filter not exists { ?stolperstein wdt:P547 []. } }
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#by CamelCaseNick
select (replace(str(?stolperstein), str(wd:), "") as ?qid) (replace(str(?commemorated), str(wd:), "") as ?P547) (replace(str(?commemorated), str(wd:), "") as ?S3452) where {
?stolperstein wdt:P31 wd:Q26703203;
wdt:P18 ?image.
?commemorated wdt:P31 wd:Q5;
wdt:P1801 ?image.
filter not exists {
?stolperstein wdt:P547 [].
}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?P547")
v6("?S3452")
v3("?commemorated"):::projected
v2("?image")
v4("?qid")
v1("?stolperstein"):::projected
a1((" "))
c5(["wd:Q5"]):::iri
c3(["wd:Q26703203"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P547"--> e0a1
e0v1("?stolperstein"):::projected
e0a1((" ")):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> a1
v1 --"wdt:P547"--> a1
v1 --"wdt:P31"--> c3
v1 --"wdt:P18"--> v2
v3 --"wdt:P31"--> c5
v3 --"wdt:P1801"--> v2
bind1[/"replace(str(?stolperstein),str('wd:'),'')"/]
v1 --o bind1
bind1 --as--o v4
bind2[/"replace(str(?commemorated),str('wd:'),'')"/]
v3 --o bind2
bind2 --as--o v5
bind3[/"replace(str(?commemorated),str('wd:'),'')"/]
v3 --o bind3
bind3 --as--o v6