Which movie of the last ten years has won the most Academy Awards? (Q187): Difference between revisions
Changed claim: mention (P38): ten |
Changed claim: mention (P38): years |
||
| Property / mention: years (English) / qualifier | |||
Revision as of 05:54, 10 February 2022
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