SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.972736943176 AND 47.332063056824 AND haendler.lng BETWEEN 7.2949792949728 AND 7.8233607050272 AND `invisible` = 0