SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.408136943176 AND 47.767463056824 AND haendler.lng BETWEEN 7.4274392505781 AND 7.9602007494219 AND `invisible` = 0