SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.83740548444838) * (sin(RADIANS(haendler.lng)) * sin(0.19981751007307) + cos(RADIANS(haendler.lng)) * cos(0.19981751007307)) - sin(RADIANS(haendler.lat)) * sin(0.83740548444838)))) AS `Distance` FROM `haendler` WHERE `id` IN (0,463991, 471608, 469907, 470344, 470864, 470664, 470504, 470259, 470297, 470415, 470489, 601272, 471254, 470623, 469896, 471152, 470313, 470301, 471282, 470004, 470968, 471164, 470641, 470435, 470305, 469754, 471252, 470532, 470460, 470017, 470473, 470215, 470123, 471248, 471404, 470118, 471110, 470723, 470087, 471413, 471420, 469726, 470167, 457322, 470887, 471255, 1375832, 470119, 469665, 470739, 471246, 470588, 469732, 471675, 867375, 469706, 663464, 471023, 561398, 419899, 470173) ORDER BY `Distance` ASC LIMIT 500 ALANA Schäftlarn 3 Produtos de ® em - lojas