SELECT DISTINCT `haendler_id` FROM `haendler2waren` WHERE `waren_id` IN (1067, 3991, 3017, 1957, 690, 34548)