query-4574993ceb6912a28d96f6757ac6d99c
J-Pop items with Latin characters in ja label but no en label
Use at
- https://query.wikidata.org/sparql
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#>
SELECT ?item ?label_ja WHERE {
?item wdt:P136 wd:Q131578 .
?item rdfs:label ?label_ja filter(lang(?label_ja) = "ja") .
MINUS { ?item rdfs:label ?label_fr filter(lang(?label_fr) = "en") . }
FILTER regex(?label_ja, "^[A-Z]*$", "i")
}
LIMIT 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v3("?label_fr")
v1("?label_ja"):::projected
c5(["wd:Q131578"]):::iri
f0[["regex(?label_ja,'^#91;A-Z#93;*$','i')"]]
f0 --> v1
f1[["?label_ja = 'ja'"]]
f1 --> v1
v2 --"wdt:P136"--> c5
v2 --"rdfs:label"--> v1
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
f3[["?label_fr = 'en'"]]
f3 --> v3
v2 --"rdfs:label"--> v3
end