what role did the designer of candide fulfill?
Entity
m.026sdt1
Costume designer
class class entity
opera.opera_designer_role opera.opera_designer_gig m.0zt6mhz
opera.opera_designer_role opera.opera_designer_gig opera.opera_production
Opera Designer Role Opera Designer Gig Candide
none none none
opera.opera_designer_gig.design_role opera.opera_production.designers
Design Role Designers
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_designer_role . 
?x1 :type.object.type :opera.opera_designer_gig . 
VALUES ?x2 { :m.0zt6mhz } 
?x1 :opera.opera_designer_gig.design_role ?x0 . 
?x2 :opera.opera_production.designers ?x1 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND opera.opera_designer_role (JOIN (R opera.opera_designer_gig.design_role) (JOIN (R opera.opera_production.designers) m.0zt6mhz)))