query-12a7c2b1322a04be81a0a88aa4198b7e
Distribution of ratings
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/>
SELECT ?film (count(distinct ?p) AS ?numberOfRatingProperties)
WHERE {
[] wdt:P31/wdt:P279* wd:Q24716199; wikibase:claim ?p .
?film wdt:P31/wdt:P279* wd:Q11424; ?p []
} GROUP BY ?film ?filmLabel ORDER BY DESC(?numberOfRatingProperties) LIMIT 10
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?film"):::projected
v4("?numberOfRatingProperties")
v2("?p"):::projected
a1((" "))
a4((" "))
a2((" "))
a3((" "))
c3(["wd:Q24716199"]):::iri
c5(["wd:Q11424"]):::iri
a1 --"wdt:P31"--> a2
a2 --"wdt:P279"--> c3
a1 --"wikibase:claim"--> v2
v3 --"wdt:P31"--> a3
a3 --"wdt:P279"--> c5
v3 -->v2--> a4
bind1[/"count(?p)"/]
v2 --o bind1
bind1 --as--o v4