SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.374036943176 AND 47.733363056824 AND haendler.lng BETWEEN 7.7280526379786 AND 8.2604673620214 AND `invisible` = 0