SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 46.803436943176 AND 47.162763056824 AND haendler.lng BETWEEN 7.2409570881483 AND 7.7676629118517 AND `invisible` = 0