query-56248300cf2225c382990dc3b4c8af03
Languages derived to
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX target: <http://www.wikidata.org/entity/Q9035>
SELECT
?count
(CONCAT("#language/", SUBSTR(STR(target:), 32), "/language/", SUBSTR(STR(?language), 32)) AS ?countUrl)
?language ?languageLabel
(CONCAT("#language/", SUBSTR(STR(?language), 32)) AS ?languageUrl)
?derived_example_lexeme ?derived_example_lexemeLabel
(CONCAT("#lexeme/", SUBSTR(STR(?derived_example_lexeme), 32)) AS ?derived_example_lexemeUrl)
WHERE {
{
SELECT
(COUNT(?lexeme) AS ?count)
?language
(SAMPLE(?derived_lexeme) AS ?derived_example_lexeme)
WHERE {
?lexeme dct:language target: ;
^wdt:P5191+ ?derived_lexeme .
?derived_lexeme dct:language ?language .
}
GROUP BY ?language
} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?derived_example_lexeme wikibase:lemma ?derived_example_lexemeLabel .
}
ORDER BY DESC(?count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?count"):::projected
v7("?countUrl")
v5("?derived_example_lexeme"):::projected
v6("?derived_example_lexemeLabel"):::projected
v9("?derived_example_lexemeUrl")
v3("?derived_lexeme")
v4("?language"):::projected
v8("?languageUrl")
v2("?lexeme")
c2([http://www.wikidata.org/entity/Q9035]):::iri
c5(["bd:serviceParam"]):::iri
c7(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v2 --"dct:language"--> c2
v3 --"wdt:P5191"--> v2
v3 --"dct:language"--> v4
bind2[/"count(?lexeme)"/]
v2 --o bind2
bind2 --as--o v5
bind3[/"sample(?derived_lexeme)"/]
v3 --o bind3
bind3 --as--o v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end
v5 --"wikibase:lemma"--> v6
bind4[/"concat('#language/',substring(str(http://www.wikidata.org/entity/Q9035),'32^^xsd:integer'),'/language/',substring(str(?language),'32^^xsd:integer'))"/]
v4 --o bind4
bind4 --as--o v7
bind5[/"concat('#language/',substring(str(?language),'32^^xsd:integer'))"/]
v4 --o bind5
bind5 --as--o v8
bind6[/"concat('#lexeme/',substring(str(?derived_example_lexeme),'32^^xsd:integer'))"/]
v5 --o bind6
bind6 --as--o v9