query-337467bd67e3a6dcbf258f0dd795f40c
By So9q
Lexemes that means (liquid) water
SELECT ?l ?sense ?lemma ?languageLabel WHERE { ?l a ontolex:LexicalEntry ; # get from the special LexicalEntry ontolex:sense ?sense ; # the sense dct:language ?language ; # the language wikibase:lemma ?lemma. # and the lemma ?sense wdt:P5137 wd:Q29053744 . # change Q29053744 to anything you want SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } }
Lower case before order
ORDER BY (LCASE(?languageLabel))
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# By So9q
# Lexemes that means (liquid) water
SELECT ?l ?sense ?lemma ?languageLabel WHERE {
?l a ontolex:LexicalEntry ; # get from the special LexicalEntry
ontolex:sense ?sense ; # the sense
dct:language ?language ; # the language
wikibase:lemma ?lemma. # and the lemma
?sense wdt:P5137 wd:Q29053744 .
# change Q29053744 to anything you want
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
# Lower case before order
ORDER BY (LCASE(?languageLabel))
Query found at
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/en
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?l"):::projected
v4("?language")
v1("?languageLabel"):::projected
v5("?lemma"):::projected
v3("?sense"):::projected
c9(["bd:serviceParam"]):::iri
c2(["ontolex:LexicalEntry"]):::iri
c7(["wd:Q29053744"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal
v2 --"a"--> c2
v2 --"ontolex:sense"--> v3
v2 --"dct:language"--> v4
v2 --"wikibase:lemma"--> v5
v3 --"wdt:P5137"--> c7
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end