find opera productions whose stage director is richard foreman.
(AND opera.opera_production (JOIN opera.opera_production.stage_director m.03jwh9))