Difference between revisions of "Which movie of the last ten years has won the most Academy Awards? (Q187)"
Jump to navigation
Jump to search
(Created claim: mention (P38): diez años) |
(Created claim: mention (P38): 10) |
||||||
Property / mention | |||||||
10 (Spanish) | |||||||
Property / mention: 10 (Spanish) / rank | |||||||
Normal rank | |||||||
Property / mention: 10 (Spanish) / qualifier | |||||||
Property / mention: 10 (Spanish) / qualifier | |||||||
numeric value: 10
|
Revision as of 05:58, 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
|
|
Statements
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