SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.424036943176 AND 47.783363056824 AND haendler.lng BETWEEN 9.8517382947419 AND 10.384661705258 AND `invisible` = 0