query-f62c27634440e0a2bd07c9e8224b1fb4

rq turtle/ttl

Missing IMDb Ids (and items) by count grouped by series:

Use at

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#>
SELECT ?series ?seriesLabel  ((?anzahl-COUNT(?episode)) AS ?count) WHERE {
  ?episode wdt:P31 wd:Q21191270 .
  ?episode wdt:P345 ?imdb .
  ?episode wdt:P179 ?series .
  ?series wdt:P1113 ?anzahl
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
} GROUP BY ?series ?seriesLabel ?anzahl ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?anzahl"):::projected v6("?count") v2("?episode") v3("?imdb") v4("?series"):::projected c7(["bd:serviceParam"]):::iri c9(["en"]):::literal c2(["wd:Q21191270"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P345"--> v3 v2 --"wdt:P179"--> v4 v4 --"wdt:P1113"--> v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end bind1[/"?anzahl - "/] v5 --o bind1 null --o bind1 bind1 --as--o v6