SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 54.580736943176 AND 54.940063056824 AND haendler.lng BETWEEN -7.766796095323 AND -7.144043904677 AND `invisible` = 0