query-61ed178139c87a11ce373ad6395ed327

rq turtle/ttl

Number of characters) (P674)characters Hi, I need a list with each episode and the number of characters (how many values of

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?label ?numberOfCharacters WHERE {
  ?item wdt:P179 wd:Q16290.
  # some magic probably using COUNT() and wdt:P674 🤷‍♀️
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en".
    ?item rdfs:label ?label.
  }
}

Query found at

https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2019/12

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?item"):::projected v2("?label"):::projected c2(["wd:Q16290"]):::iri c4(["bd:serviceParam"]):::iri c6(["en"]):::literal v1 --"wdt:P179"--> c2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 v1 --"rdfs:label"--> v2 end