SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.28402117897 AND 47.73317882103 AND haendler.lng BETWEEN 9.4955668322907 AND 10.160513167709 AND `invisible` = 0