SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) *
cos(0.82015988610942) * (sin(RADIANS(haendler.lng)) *
sin(0.2654767965331) + cos(RADIANS(haendler.lng)) *
cos(0.2654767965331)) - sin(RADIANS(haendler.lat)) * sin(0.82015988610942)))) AS `Distance`
FROM `haendler` WHERE `id` IN (0,610123, 659564, 659569, 659574, 659587, 659590, 660087, 659425, 659608, 614502, 608784, 658062, 658382, 797162, 1220462, 1546575, 1546596, 1541043, 1546574, 1546588, 1546577, 1546583, 1546633, 1546643, 1546632, 659596, 744811) ORDER BY `Distance` ASC LIMIT 500
Tanks buy in Ligist " 1 Shops
Is something missing here?
Do you have a business in Ligist? Enter it for free in a few steps.
Register now!
© 2024, Wogibtswas / Locabee. All brand names and trademarks are the property of their respective owners. All information without guarantee. Status 04.10.2024 11:01:40
UP
Choose your country and language