SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.999536943176 AND 47.358863056824 AND haendler.lng BETWEEN 7.3978059724412 AND 7.9264540275588 AND `invisible` = 0