query-338644d1039202ff564428c662136f27
Catalan label and Roman peopleHi! I need a query listing all items not having Latin label having Catalan label and English label exactly corresponding (P2358)Roman praenomen having 09:53, 11 March 2020 (UTC) dosisEpìThanks, --
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?roman_praenomen ?enlabel WHERE {
?item wdt:P2358 ?roman_praenomen .
?item rdfs:label ?enlabel .
FILTER(LANG(?enlabel) = 'en') .
?item rdfs:label ?calabel .
FILTER(LANG(?calabel) = 'ca') .
FILTER(STR(?enlabel) = STR(?calabel)) .
OPTIONAL {
?item rdfs:label ?lalabel .
FILTER(LANG(?lalabel) = 'la') .
}
FILTER(!BOUND(?lalabel)) .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?calabel")
v2("?enlabel"):::projected
v4("?item"):::projected
v1("?lalabel")
v5("?roman_praenomen"):::projected
f0[["not bound(?lalabel)"]]
f0 --> v1
f1[["str(?enlabel) = str(?calabel)"]]
f1 --> v2
f1 --> v3
f2[["?calabel = 'ca'"]]
f2 --> v3
f3[["?enlabel = 'en'"]]
f3 --> v2
v4 --"wdt:P2358"--> v5
v4 --"rdfs:label"--> v2
v4 --"rdfs:label"--> v3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."rdfs:label".-> v1
end