query-ee54f69382a3dc3dc69ce8050297aab0

rq turtle/ttl

by CamelCaseNick prefix commons:http://commons.wikimedia.org/wiki/Special:FilePath/

select (strafter(str(?commemorated), str(wd:)) as ?s) ("P1801" as ?p) (concat('"', wikibase:decodeUri(strafter(str(?image), str(commons:))), '"') as ?o) ("S3452" as ?p2) (strafter(str(?stolperstein), str(wd:)) as ?o2) where { ?stolperstein wdt:P31 wd:Q26703203; wdt:P18 ?image; wdt:P547 ?commemorated. filter(!wikibase:isSomeValue(?commemorated)) minus { ?commemorated wdt:P1801 []. } }

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#by CamelCaseNick
prefix commons:<http://commons.wikimedia.org/wiki/Special:FilePath/>

select (strafter(str(?commemorated), str(wd:)) as ?s) ("P1801" as ?p) (concat('"', wikibase:decodeUri(strafter(str(?image), str(commons:))), '"') as ?o)
 ("S3452" as ?p2) (strafter(str(?stolperstein), str(wd:)) as ?o2) where {
  ?stolperstein wdt:P31 wd:Q26703203;
                wdt:P18 ?image;
                wdt:P547 ?commemorated. filter(!wikibase:isSomeValue(?commemorated))
  minus { ?commemorated wdt:P1801 []. }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?commemorated"):::projected v3("?image"):::projected v6("?o") v8("?o2") v5("?p") v7("?p2") v4("?s") v2("?stolperstein"):::projected a1((" ")) c2(["wd:Q26703203"]):::iri f0[["not http://wikiba.se/ontology#isSomeValue(?commemorated)"]] f0 --> v1 v2 --"wdt:P31"--> c2 v2 --"wdt:P18"--> v3 v2 --"wdt:P547"--> v1 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P1801"--> a1 end bind2[/"substring-after(str(?commemorated),str('wd:'))"/] v1 --o bind2 bind2 --as--o v4 bind3[/"'P1801'"/] bind3 --as--o v5 bind4[/"concat('"',http://wikiba.se/ontology#decodeUri(substring-after(str(?image),str(http://commons.wikimedia.org/wiki/Special:FilePath/))),'"')"/] v3 --o bind4 bind4 --as--o v6 bind5[/"'S3452'"/] bind5 --as--o v7 bind6[/"substring-after(str(?stolperstein),str('wd:'))"/] v2 --o bind6 bind6 --as--o v8