SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.995036943176 AND 47.354363056824 AND haendler.lng BETWEEN 7.3337583721267 AND 7.8623616278733 AND `invisible` = 0