query-d59a2386f5419136fbb07897d19da003

rq turtle/ttl

BubbleChart Language of videos produced

Use at

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#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#title:BubbleChart Language of videos produced for Sweden outdoorgyms
#defaultView:BubbleChart
SELECT ?language (COUNT(?item) AS ?nr) WHERE {
  ?item wdt:P6104 wd:Q107186275;
    wdt:P17 wd:Q34.
  {
    ?item p:P1651 ?Pyoutubev.
    ?Pyoutubev pq:P407 ?languageid.
    ?languageid (rdfs:label?) ?language.
    FILTER((LANG(?language)) = "en")
  }
}
GROUP BY ?language
ORDER BY DESC (?publishedDate)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?Pyoutubev") v2("?item"):::projected v3("?language"):::projected v5("?languageid") v6("?nr") v1("?publishedDate") c2(["wd:Q107186275"]):::iri c4(["wd:Q34"]):::iri v2 --"p:direct/P6104"--> c2 v2 --"p:direct/P17"--> c4 f0[["?language = 'en'"]] f0 --> v3 v2 --"p:P1651"--> v4 v4 --"p:qualifier/P407"--> v5 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v5 --"rdfs:label"--> v3 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; end union0r <== or ==> union0l end bind2[/"count(?item)"/] v2 --o bind2 bind2 --as--o v6