the switch was adopted from which adapted work?
(AND media_common.adapted_work (JOIN media_common.adapted_work.adaptations m.0_9p4z6))