SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 47.420636943176 AND 47.779963056824 AND haendler.lng BETWEEN 9.0175656119134 AND 9.5504543880866 AND `invisible` = 0