SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.93747917309923) * (sin(RADIANS(haendler.lng)) * sin(0.18015812137861) + cos(RADIANS(haendler.lng)) * cos(0.18015812137861)) - sin(RADIANS(haendler.lat)) * sin(0.93747917309923)))) AS `Distance` FROM `haendler` WHERE `id` IN (55601, 54964, 2914, 25475, 12547, 55469, 53678, 54412, 53638, 715750, 21940, 12620, 2907, 12586, 21933, 2910, 54738, 54670, 54133, 54690, 53469, 53787, 721254, 53599, 53698, 713605, 12622, 715723, 2909, 12515, 54893, 2908, 12516, 713418, 54944, 54230, 54014, 2915, 12490, 711524, 527353, 21442, 21499, 2711, 715771, 53428, 53226, 55043, 2732, 54466) ORDER BY `Distance` ASC LIMIT 500 Strumpor Hammoor 1 köpa i " butiker