SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.474036943176 AND 47.833363056824 AND haendler.lng BETWEEN 9.983983261714 AND 10.517416738286 AND `invisible` = 0