SELECT DISTINCT `haendler_id` FROM `haendler2waren` WHERE `waren_id` IN (1767, 43555, 39074, 27555, 27546)