query-68280e9bbec1b66793ef66d1db292de6
(filtering names via patterns set in advance - the only diff is the 2 lines doing the filtering with regex near the end) and this again runs into timeout. As far as I understand, BIND is the sparql equivalent for setting a local variable. Seems to be a bug, that using the same regular pattern as a literal will finish in time, and using the same regular pattern set via a variable will fail. (this explains the match). I have no idea where the title in the first name comes from and how to skip those matches. Dr. Theodor (and others, all with Initials T & K), where the firstname is shown as (Q2417843)Theodor Kelter One more question / problem: running the query with D and K will yield also 12:24, 2 January 2021 (UTC)) talk (Herzi Pinki does not seem to make much difference now. best --hint:Prior hint:rangeSafe true .The 12:28, 2 January 2021 (UTC)) talk (Herzi Pinki -- I failed File:1160 Neulerchenfelder Straße 10 - Wandrelief Gründung der Gemeinde Neulerchenfeld IMG 3110.jpgfor the initial problem to identify DK on
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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#>
SELECT DISTINCT ?item ?d1 ?d2 ?nl0 ?nl1 ?itemDescription
{
?item wdt:P569 ?d1 ; wdt:P570 ?d2 .
FILTER( ?d1 > "1880-00-00"^^xsd:date &&
?d2 > "1964-00-00"^^xsd:date &&
?d1 < "1944-00-00"^^xsd:date
)
?item wdt:P735 / wdt:P1705 ?nl0 . FILTER( REGEX(?nl0, "^D" ) )
?item wdt:P734 / wdt:P1705 ?nl1 . FILTER( REGEX(?nl1, "^K" ) )
?item wdt:P106/wdt:P279* wd:Q3391743 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}