query-f40b6983b6563b29e7aed09bbfbebfe0
Shisma
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>
SELECT ?lexeme ?lemma ?derived_from ?derived_from_lemma ?lexeme_de_lemma
{
?lexeme a ontolex:LexicalEntry .
?lexeme wikibase:lemma ?lemma .
FILTER REGEX(?lemma, "^[\u30A0-\u30FF]+$") # Katakana main unicode range
?lexeme wdt:P5191 ?derived_from .
{
?lexeme_de wdt:P5191 ?derived_from .
?lexeme_de wikibase:lemma ?lexeme_de_lemma .
FILTER (LANG(?lexeme_de_lemma) = "de")
}
UNION
{
?derived_from wikibase:lemma ?derived_from_lemma
FILTER (LANG(?derived_from_lemma) = "de")
}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?derived_from"):::projected
v6("?derived_from_lemma"):::projected
v1("?lemma"):::projected
v2("?lexeme"):::projected
v5("?lexeme_de")
v4("?lexeme_de_lemma"):::projected
c3(["ontolex:LexicalEntry"]):::iri
f0[["regex(?lemma,'^#91;゠-ヿ#93;+$')"]]
f0 --> v1
v2 --"a"--> c3
v2 --"wikibase:lemma"--> v1
v2 --"wdt:P5191"--> v3
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
f1[["?derived_from_lemma = 'de'"]]
f1 --> v6
v3 --"wikibase:lemma"--> v6
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
f2[["?lexeme_de_lemma = 'de'"]]
f2 --> v4
v5 --"wdt:P5191"--> v3
v5 --"wikibase:lemma"--> v4
end
union0r <== or ==> union0l
end