Which movie of the last ten years has won the most Academy Awards? (Q187)
Revision as of 05:54, 10 February 2022 by Aidan (talk | contribs) (Changed claim: Property:P38: ten)
No description defined
- Which movie of the past decade has won the most Academy Awards?
- What film from the last 10 years has won the most Academy Awards?
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