User:TweetsFactsAndQueries/Queries/movies with best costume design awards but no costume designer

Originally posted on Mastodon. Idea by Ash Crow (User:Ash Crow).

SELECT ?film ?filmLabel ?awardLabel ?awardWinnerLabel WHERE {
  ?film wdt:P31 wd:Q11424;
        p:P166 ?awardStatement.
  ?awardStatement a wikibase:BestRank;
                  ps:P166 ?award.
  ?award wdt:P31 wd:Q96474699.
  MINUS { ?film wdt:P2515 ?costumeDesigner. }
  OPTIONAL {
    ?awardStatement pq:P1346 ?awardWinner.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY STRLEN(STR(?film)) ?film

Try it!