SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.830436943176 AND 47.189763056824 AND haendler.lng BETWEEN 6.8959539871038 AND 7.4229260128962 AND `invisible` = 0