SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 37.595236943176 AND 37.954563056824 AND haendler.lng BETWEEN -122.64629975899 AND -122.19170024101 AND `invisible` = 0