the opera designer for porgy and bess had what role in designing for that production?
Entity Entity Entity
m.026sdt1 m.0b787yg m.0181qd
Costume designer Set Designer Lighting Designer
class class entity
opera.opera_designer_role opera.opera_designer_gig m.0kfbzp7
opera.opera_designer_role opera.opera_designer_gig opera.opera_production
Opera Designer Role Opera Designer Gig Porgy and Bess
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.0kfbzp7 } 
?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.0kfbzp7)))