SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 42.098936943176 AND 42.458263056824 AND haendler.lng BETWEEN -88.274226499802 AND -87.788573500198 AND `invisible` = 0