SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.371536943176 AND 47.730863056824 AND haendler.lng BETWEEN 7.4138153370758 AND 7.9462046629242 AND `invisible` = 0