SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.886136943176 AND 47.245463056824 AND haendler.lng BETWEEN 7.3215187938544 AND 7.8490412061456 AND `invisible` = 0