SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.83951384218478) * (sin(RADIANS(haendler.lng)) * sin(0.20531529721686) + cos(RADIANS(haendler.lng)) * cos(0.20531529721686)) - sin(RADIANS(haendler.lat)) * sin(0.83951384218478)))) AS `Distance` FROM `haendler` WHERE `id` IN (419899, 469726, 470723, 471164, 457297, 663464, 470887, 470435, 470187, 471110, 471413, 470173, 471404, 470684, 470087, 470017, 471252, 470664, 470119, 470004, 470623, 470473, 471608, 469754, 470167, 470297, 471420, 470489, 470313, 561398, 867375, 471255, 469732, 469706, 463991, 1375832, 470259, 470460, 470504, 471023, 470864, 470641, 469665, 471248, 469907, 469896, 470123, 470739, 470344, 470305, 471152, 471282, 470301, 470335, 470078, 459500, 471299, 469890, 471522, 459513, 460686, 471195, 470199, 459495, 471540, 469793, 470886, 471117, 470649, 470195, 471014, 471249) ORDER BY `Distance` ASC LIMIT 500 PUSBLU Grasbrunn 2 Produtos de ® em - lojas