Difference between revisions of "Which movie of the last ten years has won the most Academy Awards? (Q187)"

@@ aliases / en / 0 / aliases / en / 0 @@
+Which movie of the past decade has won the most Oscars?
@@ aliases / en / 1 / aliases / en / 1 @@
-Which movie of the past decade has won the most Academy Awards?
@@ aliases / es / 0 / aliases / es / 0 @@
+¿Cuál película de la última década ganó el mayor número de Premios Óscar?
@@ aliases / es / 1 / aliases / es / 1 @@
-¿Cuál película de la última década ha ganado el mayor número de Premios Óscar?
@@ Property / instance of @@
+question
@@ Property / instance of: question / rank @@
+Normal rank
@@ Property / query @@
+SELECT ?sbj WHERE { { SELECT ?sbj (MIN(?obj) AS ?obj1) WHERE { ?sbj wdt:P31/wdt:P279* wd:Q11424 . ?sbj wdt:P577 ?obj . } GROUP BY ?sbj } ?sbj wdt:P166 ?obj2 . ?obj2 wdt:P31/wdt:P279* wd:Q19020 . FILTER(YEAR(NOW())-YEAR(?obj1)-IF(MONTH(NOW())>MONTH(?obj1),0,IF(MONTH(NOW())=MONTH(?obj1) && DAY(NOW())>=DAY(?obj1),0,1))< 10) } GROUP BY (?sbj) ORDER BY DESC(COUNT(DISTINCT ?obj2)) LIMIT 1
+Normal rank
+query language: SPARQL
+dataset: Wikidata
@@ Property / mention @@
+movie (English)
@@ Property / mention: movie (English) / rank @@
+Normal rank
@@ Property / mention: movie (English) / qualifier @@
+Wikidata item ID: Q11424
@@ Property / mention @@
+ten (English)
@@ Property / mention: ten (English) / rank @@
+Normal rank
@@ Property / mention: ten (English) / qualifier @@
+Wikidata item ID: Q23806
@@ Property / mention: ten (English) / qualifier @@
+numeric value: 10
Amount 10
Unit 1
 Amount
 Unit
@@ Property / mention @@
+years (English)
@@ Property / mention: years (English) / rank @@
+Normal rank
@@ Property / mention: years (English) / qualifier @@
+Wikidata item ID: Q577
@@ Property / mention: years (English) / qualifier @@
+Wikidata item ID: Q24564698
@@ Property / mention @@
+won (English)
@@ Property / mention: won (English) / rank @@
+Normal rank
@@ Property / mention: won (English) / qualifier @@
+Wikidata item ID: Q50000
@@ Property / mention: won (English) / qualifier @@
+Wikidata property ID: P166
@@ Property / mention @@
+Academy Awards (English)
@@ Property / mention: Academy Awards (English) / rank @@
+Normal rank
@@ Property / mention: Academy Awards (English) / qualifier @@
+Wikidata item ID: Q19020
@@ Property / mention @@
+decade (English)
@@ Property / mention: decade (English) / rank @@
+Normal rank
@@ Property / mention: decade (English) / qualifier @@
+Wikidata item ID: Q39911
@@ Property / mention @@
+(English)
@@ Property / mention: 10 (English) / rank @@
+Normal rank
@@ Property / mention: 10 (English) / qualifier @@
+Wikidata item ID: Q23806
@@ Property / mention: 10 (English) / qualifier @@
+numeric value: 10
Amount 10
Unit 1
 Amount
 Unit
@@ Property / mention @@
+Oscars (English)
@@ Property / mention: Oscars (English) / rank @@
+Normal rank
@@ Property / mention: Oscars (English) / qualifier @@
+Wikidata item ID: Q19020
@@ Property / mention @@
+película (Spanish)
@@ Property / mention: película (Spanish) / rank @@
+Normal rank
@@ Property / mention: película (Spanish) / qualifier @@
+Wikidata item ID: Q11424
@@ Property / mention @@
+diez (Spanish)
@@ Property / mention: diez (Spanish) / rank @@
+Normal rank
@@ Property / mention: diez (Spanish) / qualifier @@
+Wikidata item ID: Q23806
@@ Property / mention: diez (Spanish) / qualifier @@
+numeric value: 10
Amount 10
Unit 1
 Amount
 Unit
@@ Property / mention @@
+años (Spanish)
@@ Property / mention: años (Spanish) / rank @@
+Normal rank
@@ Property / mention: años (Spanish) / qualifier @@
+Wikidata item ID: Q577
@@ Property / mention: años (Spanish) / qualifier @@
+Wikidata item ID: Q24564698
@@ Property / mention @@
+ganado (Spanish)
@@ Property / mention: ganado (Spanish) / rank @@
+Normal rank
@@ Property / mention: ganado (Spanish) / qualifier @@
+Wikidata item ID: Q50000
@@ Property / mention: ganado (Spanish) / qualifier @@
+Wikidata property ID: P166
@@ Property / mention @@
+número (Spanish)
@@ Property / mention: número (Spanish) / rank @@
+Normal rank
@@ Property / mention: número (Spanish) / qualifier @@
+Wikidata item ID: Q11563
@@ Property / mention @@
+Premios Óscar (Spanish)
@@ Property / mention: Premios Óscar (Spanish) / rank @@
+Normal rank
@@ Property / mention: Premios Óscar (Spanish) / qualifier @@
+Wikidata item ID: Q19020
@@ Property / mention @@
+Premios de la Academia (Spanish)
@@ Property / mention: Premios de la Academia (Spanish) / rank @@
+Normal rank
@@ Property / mention: Premios de la Academia (Spanish) / qualifier @@
+Wikidata item ID: Q19020
@@ Property / mention @@
+década (Spanish)
@@ Property / mention: década (Spanish) / rank @@
+Normal rank
@@ Property / mention: década (Spanish) / qualifier @@
+Wikidata item ID: Q39911
@@ Property / mention @@
+años (Spanish)
@@ Property / mention: 10 años (Spanish) / rank @@
+Normal rank
@@ Property / mention: 10 años (Spanish) / qualifier @@
+Wikidata item ID: Q39911
@@ Property / mention @@
+diez años (Spanish)
@@ Property / mention: diez años (Spanish) / rank @@
+Normal rank
@@ Property / mention: diez años (Spanish) / qualifier @@
+Wikidata item ID: Q39911
@@ Property / mention @@
+(Spanish)
@@ Property / mention: 10 (Spanish) / rank @@
+Normal rank
@@ Property / mention: 10 (Spanish) / qualifier @@
+Wikidata item ID: Q23806
@@ Property / mention: 10 (Spanish) / qualifier @@
+numeric value: 10
Amount 10
Unit 1
 Amount
 Unit
@@ Property / mention @@
+ganó (Spanish)
@@ Property / mention: ganó (Spanish) / rank @@
+Normal rank
@@ Property / mention: ganó (Spanish) / qualifier @@
+Wikidata item ID: Q50000
@@ Property / mention: ganó (Spanish) / qualifier @@
+Wikidata property ID: P166

Latest revision as of 22:07, 10 February 2022

No description defined

What film from the last 10 years has won the most Academy Awards?
Which movie of the past decade has won the most Oscars?

Language	Label	Description	Also known as
English	Which movie of the last ten years has won the most Academy Awards?	No description defined	What film from the last 10 years has won the most Academy Awards? Which movie of the past decade has won the most Oscars?

Statements

instance of

question

0 references

query

SELECT ?sbj WHERE { { SELECT ?sbj (MIN(?obj) AS ?obj1) WHERE { ?sbj wdt:P31/wdt:P279* wd:Q11424 . ?sbj wdt:P577 ?obj . } GROUP BY ?sbj } ?sbj wdt:P166 ?obj2 . ?obj2 wdt:P31/wdt:P279* wd:Q19020 . FILTER(YEAR(NOW())-YEAR(?obj1)-IF(MONTH(NOW())>MONTH(?obj1),0,IF(MONTH(NOW())=MONTH(?obj1) && DAY(NOW())>=DAY(?obj1),0,1))< 10) } GROUP BY (?sbj) ORDER BY DESC(COUNT(DISTINCT ?obj2)) LIMIT 1

0 references

movie (English)

Difference between revisions of "Which movie of the last ten years has won the most Academy Awards? (Q187)"

10

10

10

10

Latest revision as of 22:07, 10 February 2022

Statements

Navigation menu

Search