SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 40.473536943176 AND 40.832863056824 AND haendler.lng BETWEEN -112.16681420388 AND -111.69318579612 AND `invisible` = 0