query-f1c51715549cc118e2a8c7fe5dc8be3f
.on Mastodon and on TwitterOriginally posted
Use at
- https://query.wikidata.org/sparql
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
# most common languages of quotes in references
#defaultView:BarChart
SELECT ?lang (COUNT(?statement) AS ?count) WHERE {
?statement prov:wasDerivedFrom ?reference.
?reference pr:P1683 ?quote.
BIND(LANG(?quote) AS ?lang)
}
GROUP BY ?lang
ORDER BY DESC(?count)
LIMIT 25
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?count")
v5("?lang"):::projected
v4("?quote")
v3("?reference")
v2("?statement"):::projected
v2 --"prov:wasDerivedFrom"--> v3
v3 --"pr:P1683"--> v4
bind0[/"?quote"/]
v4 --o bind0
bind0 --as--o v5
bind2[/"count(?statement)"/]
v2 --o bind2
bind2 --as--o v6