SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.91077039955596) * (sin(RADIANS(haendler.lng)) * sin(0.20565738175025) + cos(RADIANS(haendler.lng)) * cos(0.20565738175025)) - sin(RADIANS(haendler.lat)) * sin(0.91077039955596)))) AS `Distance` FROM `haendler` WHERE `id` IN (3010, 3011, 12543, 19154, 139536, 157104, 713245, 713370, 714628, 716154, 716367, 717328, 53553, 53602, 53694, 53907, 53930, 54170, 54552, 54717, 54969, 55024, 55033, 55153, 55552, 55589, 55653, 55762, 527433) ORDER BY `Distance` ASC LIMIT 500 Sokker Körbelitz 0 køb i " butikker