query-d787a268effe7b5f41b1bcdaa8d1ee7f

Diagram of the languages usage in podcasts

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 bd: <http://www.bigdata.com/rdf#>
#Popular languages used in podcasts
#title:Main language used in a podcast
#illustrates bubblechart view, count

#defaultView:BubbleChart
SELECT ?language ?languageLabel (COUNT(?languages) AS ?count)
WHERE
{
  ?languages wdt:P31 wd:Q24634210.
  ?languages wdt:P407 ?language.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?language ?languageLabel
ORDER BY DESC(?count)

Query found at

https://www.wikidata.org/wiki/Talk:Q24634210

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?count") v3("?language"):::projected v2("?languages"):::projected c5(["bd:serviceParam"]):::iri c7(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wd:Q24634210"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P407"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end bind1[/"count(?languages)"/] v2 --o bind1 bind1 --as--o v4