which is the role of opera designer gig who designed the chocolate soldier?
(AND opera.opera_designer_role (JOIN (R opera.opera_designer_gig.design_role) (JOIN (R opera.opera_production.designers) m.0q49ph1)))