what is the {statement is subject of} for {Mel Gibson} has {award received} as {Academy Award for Best Picture} ?
In what movie did Mel Gibson win the Academy Award for Best Picture?
For which movie has Mel Gibson received and Academy Award for Best Picture?
SELECT ?i WHERE { ?d property:statement_is_subject_of ?i . ?d property:award_received resource:Academy_Award_for_Best_Picture . resource:Mel_Gibson property:award_received ?d }
select distinct ?value  where {
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> <http://wikidata.dbpedia.org/resource/Q42229> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P166> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q102427> .
?statement <http://www.wikidata.org/entity/P805> ?value. 
} 

SELECT ?value WHERE { wd:Q42229 p:P166 ?s . ?s ps:P166 wd:Q102427 . ?s pq:P805 ?value}