query-f95a8ab465beda3518b1160d860a913c
all items for names with Latin script (generally just one per spelling, a few incorrect ones mixed in (e.g. in Cyrillic) SELECT ?item ?nl ?id WHERE { ?item wdt:P31 wd:Q101352; wdt:P282 wd:Q8229 . MINUS { ?item wdt:P282 ?ws . FILTER(?ws != wd:Q8229 ) } ?item wdt:P1705 ?nl OPTIONAL { ?item wdt:P6597 ?id } }
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#all items for names with Latin script (generally just one per spelling, a few incorrect ones mixed in (e.g. in Cyrillic)
SELECT ?item ?nl ?id
WHERE
{
?item wdt:P31 wd:Q101352; wdt:P282 wd:Q8229 .
MINUS { ?item wdt:P282 ?ws . FILTER(?ws != wd:Q8229 ) }
?item wdt:P1705 ?nl
OPTIONAL { ?item wdt:P6597 ?id }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?id"):::projected
v1("?item"):::projected
v3("?nl"):::projected
v2("?ws")
c2(["wd:Q101352"]):::iri
c4(["wd:Q8229"]):::iri
v1 --"wdt:P31"--> c2
v1 --"wdt:P282"--> c4
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
f1[["?ws != 'wd:Q8229'"]]
f1 --> v2
v1 --"wdt:P282"--> v2
end
v1 --"wdt:P1705"--> v3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P6597".-> v4
end