SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 33.742936943176 AND 34.102263056824 AND haendler.lng BETWEEN -117.75451571593 AND -117.32148428407 AND `invisible` = 0