SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.320336943176 AND 47.679663056824 AND haendler.lng BETWEEN 7.2923150370615 AND 7.8241849629385 AND `invisible` = 0