SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.994422261923 AND 47.551377738077 AND haendler.lng BETWEEN 8.3100829045997 AND 9.1309370954003 AND `invisible` = 0