SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.93630631184189) * (sin(RADIANS(haendler.lng)) * sin(0.17097943484237) + cos(RADIANS(haendler.lng)) * cos(0.17097943484237)) - sin(RADIANS(haendler.lat)) * sin(0.93630631184189)))) AS `Distance` FROM `haendler` WHERE `id` IN (112043, 370327, 112054, 111989, 111988, 112087, 599967, 370326, 112042, 727398, 730220, 727399, 112045, 112076, 316496, 112049, 289611, 604423, 112038, 112004, 553534, 1463247) ORDER BY `Distance` ASC LIMIT 500 Schöller Pinneberg 0 Produkter fra ® i - butikker