SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.93721911904068) * (sin(RADIANS(haendler.lng)) * sin(0.16996714387622) + cos(RADIANS(haendler.lng)) * cos(0.16996714387622)) - sin(RADIANS(haendler.lat)) * sin(0.93721911904068)))) AS `Distance` FROM `haendler` WHERE `id` IN (0,341068, 341063, 341071, 341073, 680203, 800580, 800584, 1412665, 222497, 450850, 450915, 450682, 449663, 450927, 449850, 450586, 450721, 450937, 450675, 449680, 450395, 450738, 451168, 451246, 451086, 451886, 564434, 451879, 451753, 451991, 455925, 456318, 456101, 456027, 455955, 450556, 1224074, 450859, 365436, 365669, 365363, 365370, 365365, 365366, 365099, 365360, 365357, 365434, 365105, 365433, 365039, 365107, 451938, 450393, 365673, 365368, 450753) ORDER BY `Distance` ASC LIMIT 500 Hörselskydd Tornesch 0 köpa i " butiker