scottish opera produced which operatic production?
Entity Entity Entity Entity Entity Entity Entity
m.0n9_ftb m.0y__5s3 m.0y4q8xj m.0y4sx25 m.0zf5kmh m.0z56czm m.0zfjn1k
American Lulu Candide In the Locked Room/Ghost Patrol Clemency From The House of the Dead The Trojans Manon Lescaut
class entity
opera.opera_production m.025x84
opera.opera_production opera.opera_company
Opera Production Scottish Opera
none none
opera.opera_production.producing_company
Producing Company
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <http://rdf.freebase.com/ns/> 
SELECT (?x0 AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :opera.opera_production . 
VALUES ?x1 { :m.025x84 } 
?x0 :opera.opera_production.producing_company ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(AND opera.opera_production (JOIN opera.opera_production.producing_company m.025x84))