SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.93844259484633) * (sin(RADIANS(haendler.lng)) * sin(0.1850485339427) + cos(RADIANS(haendler.lng)) * cos(0.1850485339427)) - sin(RADIANS(haendler.lat)) * sin(0.93844259484633)))) AS `Distance` FROM `haendler` WHERE `id` IN (0,294205, 781104, 809560, 727834, 294224, 1520115, 727965, 294270, 400297, 531710, 750566, 371922, 747607, 339096, 125900, 749239, 750493, 751441, 811712, 751102, 695813, 1226110, 771804, 747731, 1239302, 1491184, 1226114, 1613723, 774654, 750939, 747859, 750800, 747444, 1383657, 727959, 774593, 749579, 749795, 750214, 751082, 1207648, 746238, 294701, 746288, 747543, 747367) ORDER BY `Distance` ASC LIMIT 500 Direkte forsikring i Bliestorf - 1 Tjenesteudbyder