SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.91077039955596) * (sin(RADIANS(haendler.lng)) * sin(0.18616903532248) + cos(RADIANS(haendler.lng)) * cos(0.18616903532248)) - sin(RADIANS(haendler.lat)) * sin(0.91077039955596)))) AS `Distance` FROM `haendler` WHERE `id` IN (533088, 390450, 587305, 533929, 390757, 540446, 130921, 1450781, 130925, 1606558, 130899, 130937, 352193, 130904, 1505907, 565414, 222754, 792279, 585599, 369241, 581706, 500880, 756735, 1477310, 1477405, 1488330, 612679, 130933, 237413, 540631, 160730, 507425, 130894, 60887, 734562, 540237, 560270, 130924, 163659, 390758, 708897, 159553, 366719, 784695, 390099, 130939, 691839, 680279, 130903, 130886, 638004, 130890, 203975, 130891, 130896) ORDER BY `Distance` ASC LIMIT 500 Onroerend goed Dettum 2 kopen in " winkels