SELECT DISTINCT `haendler_id` FROM `haendler2waren` WHERE `waren_id` IN (9564, 78338, 47397, 47396)