SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.93833962042046) * (sin(RADIANS(haendler.lng)) * sin(0.17169083104549) + cos(RADIANS(haendler.lng)) * cos(0.17169083104549)) - sin(RADIANS(haendler.lat)) * sin(0.93833962042046)))) AS `Distance` FROM `haendler` WHERE `id` IN (44821, 115166, 115169, 114847, 98080, 257990, 118807, 97921, 115569, 396210, 640007, 20560, 381542, 640657, 115500, 115142, 116019, 459305, 115571, 228191, 382137, 115499, 120994, 98102, 90572, 296720, 576457, 116011, 90889, 98247, 131938, 97884, 114808, 459124, 114795, 585611) ORDER BY `Distance` ASC LIMIT 500 Apple Hemdingen 0 Produkter fra ® i - butikker