SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.316436943176 AND 47.675763056824 AND haendler.lng BETWEEN 7.8180447894286 AND 8.3498752105714 AND `invisible` = 0