SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.314136943176 AND 47.673463056824 AND haendler.lng BETWEEN 7.9203564363075 AND 8.4521635636925 AND `invisible` = 0