SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 42.552836943176 AND 42.912163056824 AND haendler.lng BETWEEN -84.80009600696 AND -84.31090399304 AND `invisible` = 0