query-8d7c0166669af6988901642c9d734f06

rq turtle/ttl

الشخصيات المصورة من قبل أكثر الممثلين Characters portrayed by most actors Characters portrayed by most actors Postavy ztvárněné nejvíce herci Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Personnages joués par la plupart des acteurs Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Personaggi ritratti dalla maggior parte degli attori Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Personages gespeeld door de meeste acteurs Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Персонажи, изображавшиеся наибольшим числом актёров Characters portrayed by most actors Karaktärer som porträtterats av flest skådespelare Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors Characters portrayed by most actors 最多演员刻画过的角色

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?character ?characterLabel (COUNT(?actor) AS ?count)
WHERE
{
  {
    SELECT DISTINCT ?character ?actor
    WHERE {
      ?film p:P161 [
        ps:P161 ?actor;
        pq:P453 ?character
      ].
      #?character wdt:P31 wd:Q5. # uncomment to filter for real people
    }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
GROUP BY ?character ?characterLabel
ORDER BY DESC(?count)
LIMIT 25

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?actor"):::projected v3("?character"):::projected v5("?count") v4("?film") a1((" ")) c5(["bd:serviceParam"]):::iri c7(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal a1 --"p:statement/P161"--> v2 a1 --"p:qualifier/P453"--> v3 v4 --"p:P161"--> a1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end bind1[/"count(?actor)"/] v2 --o bind1 bind1 --as--o v5