SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.910136943176 AND 47.269463056824 AND haendler.lng BETWEEN 6.9503999644533 AND 7.4781600355467 AND `invisible` = 0