SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.842136943176 AND 47.201463056824 AND haendler.lng BETWEEN 7.1867862500122 AND 7.7138737499878 AND `invisible` = 0