query-8bf07da8b2569be81c086666ab04c09d

rq turtle/ttl

by CamelCaseNick select (replace(str(?stolperstein), str(wd:), "") as ?qid) ?Lde where { ?stolperstein wdt:P31 wd:Q26703203. filter not exists { ?stolperstein rdfs:label ?de. filter(lang(?de) = "de") } ?stolperstein rdfs:label ?en. filter(lang(?en) = "en") filter(strstarts(?en, "Stolperstein dedicated to ")) bind(replace(?en, "Stolperstein dedicated to ", "Stolperstein für ") as ?Lde) }

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#by CamelCaseNick
select (replace(str(?stolperstein), str(wd:), "") as ?qid) ?Lde where {
  ?stolperstein wdt:P31 wd:Q26703203.
  filter not exists {
    ?stolperstein rdfs:label ?de.
    filter(lang(?de) = "de")
  }
  ?stolperstein rdfs:label ?en.
  filter(lang(?en) = "en")
  filter(strstarts(?en, "Stolperstein dedicated to "))
  bind(replace(?en, "Stolperstein dedicated to ", "Stolperstein für ") as ?Lde)
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?Lde"):::projected v2("?de") v1("?en") v5("?qid") v3("?stolperstein"):::projected c6(["wd:Q26703203"]):::iri f0[["starts-with(?en,'Stolperstein dedicated to ')"]] f0 --> v1 f1[["?en = 'en'"]] f1 --> v1 f2[["not "]] subgraph f2e0["Exists Clause"] e0f0[["?de = 'de'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v1("?de"):::projected e0v2("?stolperstein"):::projected end f2--EXISTS--> f2e0 f2 --> v2 f2 --> v3 f2 --> c4 f3[["?de = 'de'"]] f3 --> v2 v3 --"rdfs:label"--> v2 v3 --"wdt:P31"--> c6 v3 --"rdfs:label"--> v1 bind4[/"replace(?en,'Stolperstein dedicated to ','Stolperstein für ')"/] v1 --o bind4 bind4 --as--o v4 bind5[/"replace(str(?stolperstein),str('wd:'),'')"/] v3 --o bind5 bind5 --as--o v5