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 (471246, 471254, 470118, 471675, 419899, 469726, 470723, 471164, 601272, 470415, 663464, 470887, 470435, 471110, 471413, 470173, 471404, 470087, 470017, 471252, 470664, 470119, 457322, 470004, 470623, 470473, 471608, 469754, 470167, 470297, 471420, 470489, 470313, 561398, 867375, 471255, 469732, 469706, 463991, 1375832, 470259, 470460, 470504, 470532, 471023, 470864, 470641, 469665, 471248, 469907, 469896, 470588, 470215, 470968, 470123, 470739, 470344, 470305, 471152, 471282, 470301) ORDER BY `Distance` ASC LIMIT 500 Jessa Schäftlarn 3 Productos de ® en - tiendas