query-44c33781bd90efb37911d8bff68bf274

Language

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#defaultView:BubbleChart
SELECT ?cid ?cause (count(*) as ?count)
WHERE
{
  ?pid wdt:P31 wd:Q24634210 .
  ?pid wdt:P407 ?cid .
  OPTIONAL {
    ?cid rdfs:label ?cause filter (lang(?cause) = "en") .
  }
}
GROUP BY ?cid ?cause
ORDER BY DESC(?count) ASC(?cause)

Query found at

https://www.wikidata.org/wiki/User:Trade/podcasts/query

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?cause"):::projected v4("?cid"):::projected v5("?count") v3("?pid") c3(["wd:Q24634210"]):::iri v3 --"wdt:P31"--> c3 v3 --"wdt:P407"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."rdfs:label".-> v2 end bind1[/"count(*)"/] bind1 --as--o v5