query-76244477524b86b4c7483d04d7d8e178

rq turtle/ttl

title:Persone con almeno un id ed etichetta o alias italiani contenenti una virgola e non contenenti "di" o "de" SELECT DISTINCT ?person ?label_alias WHERE { ?person wdt:P8750 ?id . ?person wdt:P31 wd:Q5 . ?person ?s ?label_alias . FILTER(LANG(?label_alias) = "it") VALUES ?s { rdfs:label skos:altLabel } . FILTER(REGEX(?label_alias, ",")) FILTER(!REGEX(?label_alias, " d(i|e)")) }

Use at

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#>
#title:Persone con almeno un id ed etichetta o alias italiani contenenti una virgola e non contenenti "di" o "de"
SELECT DISTINCT ?person ?label_alias
WHERE {
  ?person wdt:P8750 ?id .
  ?person wdt:P31 wd:Q5 .
  ?person ?s ?label_alias . FILTER(LANG(?label_alias) = "it")
  VALUES ?s { rdfs:label skos:altLabel } .
  FILTER(REGEX(?label_alias, ","))
  FILTER(!REGEX(?label_alias, " d(i|e)"))
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?id") v1("?label_alias"):::projected v2("?person"):::projected v5("?s") c6(["wd:Q5"]):::iri f0[["not regex(?label_alias,' d(i|e)')"]] f0 --> v1 f1[["regex(?label_alias,',')"]] f1 --> v1 f2[["?label_alias = 'it'"]] f2 --> v1 v2 --"wdt:P8750"--> v3 v2 --"wdt:P31"--> c6 v2 -->v5--> v1 bind3[/VALUES ?s/] bind3-->v5 bind30(["rdfs:label"]) bind30 --> bind3 bind31(["skos:altLabel"]) bind31 --> bind3