SELECT DISTINCT `haendler_id` FROM `haendler2waren` WHERE `waren_id` IN (1267, 7308, 2269, 1216, 1172, 75812, 2348, 1235, 2293)