query-8491e458a03d5d0df9174aa963ae0054

rq turtle/ttl

by CamelCaseNick select (replace(str(?stolperstein), str(wd:), "") as ?qid) ?Ade where { ?stolperstein wdt:P31 wd:Q26703203; rdfs:label ?de. filter(lang(?de) = "de") filter(regex(?de, "^Stolperstein für (\p{L}+) („\p{L}+“|‚\p{L}+‘|\"\p{L}+\"|'\p{L}+'|\(\p{L}+\)) (\p{L}+)$")) bind(replace(?de, "^Stolperstein für (\p{L}+) („\p{L}+“|‚\p{L}+‘|\"\p{L}+\"|'\p{L}+'|\(\p{L}+\)) (\p{L}+)$", "$1 $3") as ?name) bind(concat("Stolperstein für ", ?name) as ?Ade) filter not exists { ?stolperstein skos:altLabel ?alias. filter(?alias = strlang(?Ade, "de")) } }

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#by CamelCaseNick
select (replace(str(?stolperstein), str(wd:), "") as ?qid) ?Ade where {
  ?stolperstein wdt:P31 wd:Q26703203;
                rdfs:label ?de.
  filter(lang(?de) = "de")
  filter(regex(?de, "^Stolperstein für (\\p{L}+) („\\p{L}+“|‚\\p{L}+‘|"\\p{L}+"|'\\p{L}+'|\\(\\p{L}+\\)) (\\p{L}+)$"))
  bind(replace(?de, "^Stolperstein für (\\p{L}+) („\\p{L}+“|‚\\p{L}+‘|"\\p{L}+"|'\\p{L}+'|\\(\\p{L}+\\)) (\\p{L}+)$", "$1 $3") as ?name)
  bind(concat("Stolperstein für ", ?name) as ?Ade)
  filter not exists {
    ?stolperstein skos:altLabel ?alias.
    filter(?alias = strlang(?Ade, "de"))
  }
}

Query found at

• https://www.wikidata.org/wiki/User:CamelCaseNick/Stolpersteine