query-2c98a03a5f1ddc64efbb90461410a53f

rq turtle/ttl

more episodes) episodes), The Flintstones (episodes), NCIS: Los Angeles (episodes), Lindenstraße (episodes), Ellen (episodes), Wacky Races (episodes), PAW Patrol (episodes), Inspector Rex (episodes), MAS*H (episodes), Die Biene Maja (episodes), Eine für alle – Frauen können’s besser (episodes), Will & Grace (episodes), CSI: Crime Scene Investigation (episodes), Corn and cluck (episodes), Stargate Universe (episodes), Grey’s Anatomy (episodes), Two and a Half Men (episodes), Vízipók-csodapók (episodes), Bones (episodes), JAG (episodes), Mayday (episodes), King of the Hill (episodes), The Kapil Sharma Show (episodes), The A-Team (episodes), Twin Peaks (episodes), Star Wars: The Clone Wars (episodes), Law & Order: Trial by Jury (episodes), Kaamelott (episodes), Szomszédok (episodes), Xena: Warrior Princess (episodes), Pastewka (episodes), Holby City (episodes), Casualty (episodes), SpongeBob SquarePants (episodesThe Sopranos (

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wdno: <http://www.wikidata.org/prop/novalue/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?serie ?serieLabel (COUNT(?episode) AS ?count) WHERE {
  ?episode wdt:P31 wd:Q21191270 .
  ?episode wdt:P179 ?serie
  MINUS { ?episode wdt:P345 [] }
  MINUS { ?episode rdf:type wdno:P345 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
} GROUP BY ?serie ?serieLabel ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?count") v2("?episode"):::projected v3("?serie"):::projected a1((" ")) c8(["bd:serviceParam"]):::iri c6(["wdno:P345"]):::iri c10(["en"]):::literal c2(["wd:Q21191270"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P179"--> v3 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P345"--> a1 end subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"a"--> c6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end bind3[/"count(?episode)"/] v2 --o bind3 bind3 --as--o v4