query-088cbf5407b250855a0504e051543f08

rq turtle/ttl

Both querys work well. I dont know why the first is not show correct, maybe the regex is a problem. - Now I try to combine both querys (like a join). But I get a servererror.

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?item ?label_de ?lastname ?itemlastname
WHERE 
{
  SERVICE bd:slice {
    ?item wdt:P31 wd:Q5 .
    bd:serviceParam bd:slice.offset 0 .      # Offset 
    bd:serviceParam bd:slice.limit 5000 .   #  number of datasets to scan
  }      
  MINUS { ?item wdt:P734 [] } .              # no family name

  ?item rdfs:label ?label_de .               # only german label
  FILTER(LANG(?label_de) = 'de') .  

  FILTER(REGEX(STR(?label_de), "[^,]")) .    # no commas  "Prinzessin Elisabeth Helene, Markgrafin von Meißen"
  FILTER(!REGEX(STR(?label_de), "[0-9]")) .  # no number   "12th Planet" 
  FILTER(!REGEX(STR(?label_de), "\\?")) .    # no Question mark  "A.geh Wirklich?" 
  FILTER(!REGEX(STR(?label_de), "\\-")) .    # no minus  "Adib asch-Schischakli" 
  FILTER(REGEX(STR(?label_de), " ")) .       # minimum one space z.B.  "Athenagoras"
  FILTER(!REGEX(STR(?label_de), "\\.$")) .   # no point at the end  "Johann Reinhard III."
  FILTER(!REGEX(STR(?label_de), " (von|de|le|der|die|das|dem) ")) .  # no nobiliary particle   "Anton Günther Herzog von Oldenburg"

  # only since 1875
  OPTIONAL { ?item wdt:P569 ?date_of_birth }. # date of birth
  FILTER (?date_of_birth >= "1875-01-01T00:00:00Z"^^xsd:dateTime)  

  BIND(REPLACE(?label_de, "^.* ([^\\s]+)$", "$1") AS ?lastname)  # get lastname
  FILTER(REGEX(STR(?lastname), "....*")) .                       # minimum 3 letters  

  SERVICE bd:slice {
    ?itemlastname wdt:P31 wd:Q101352  .
    bd:serviceParam bd:slice.offset 0 .
    bd:serviceParam bd:slice.limit 1000 .
  }   

  FILTER (?lastname = ?itemlastnameLabel) .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". } 
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2023/01