SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 34.237836943176 AND 34.597163056824 AND haendler.lng BETWEEN -119.48978900371 AND -119.05421099629 AND `invisible` = 0