SELECT DISTINCT `haendler_id` FROM `haendler2waren` WHERE `waren_id` IN (1146, 237373, 237371, 15518, 15508, 1084, 1197)