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