SELECT DISTINCT `haendler_id` FROM `haendler2waren` WHERE `waren_id` IN (237, 50710, 45450, 30983, 26089, 26083)