SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.470336943176 AND 47.829663056824 AND haendler.lng BETWEEN 7.3833021578438 AND 7.9166978421562 AND `invisible` = 0