SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.9164514462712) * (sin(RADIANS(haendler.lng)) * sin(0.22828906616086) + cos(RADIANS(haendler.lng)) * cos(0.22828906616086)) - sin(RADIANS(haendler.lat)) * sin(0.9164514462712)))) AS `Distance` FROM `haendler` WHERE `id` IN (79, 407172, 78197, 582887, 86, 332, 139228, 3749, 58072, 805602, 90, 139234, 646949, 314, 153892, 27779, 30986, 1523268, 139225, 440, 139239, 1411029, 50703, 139220, 560588, 710567, 58208, 44783, 393, 139249, 139248, 57917, 139250, 46239, 139253, 58278, 711521, 695961) ORDER BY `Distance` ASC LIMIT 500 Tyger Dallgow-Döberitz 0 köpa i " butiker