SELECT DISTINCT `id` FROM `haendler` WHERE haendler.lat BETWEEN 42.801136943176 AND 43.160463056824 AND haendler.lng BETWEEN -78.84008150366 AND -78.34891849634 AND `invisible` = 0