SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 54.620536943176 AND 54.979863056824 AND haendler.lng BETWEEN -1.9277526396101 AND -1.3043873603899 AND `invisible` = 0