SELECT DISTINCT `haendler_id` FROM `haendler2waren` WHERE `waren_id` IN (28, 47683, 47680)