query-e9ed1f9a0e5d28ccfe72180b9166bcbe
SPARQL template problem and filter count questionHi! I've got two new questions. 1. Why is the template not working here?
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?actor (COUNT(?film) AS ?films) WHERE {
{SELECT DISTINCT ?actor ?film WHERE {
VALUES ?film {wd:Q172241 wd:Q47703 wd:Q184768} .
?film wdt:P161 ?actor
} }
} GROUP BY ?actor ORDER BY DESC(?films)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?actor"):::projected
v2("?film"):::projected
v4("?films")
bind0[/VALUES ?film/]
bind0-->v2
bind00(["wd:Q172241"])
bind00 --> bind0
bind01(["wd:Q47703"])
bind01 --> bind0
bind02(["wd:Q184768"])
bind02 --> bind0
v2 --"wdt:P161"--> v3
bind2[/"count(?film)"/]
v2 --o bind2
bind2 --as--o v4