SELECT A.DISTRICT_CODE AS CODE, DISTRICT_NAME AS NAME, A.LATITUDE AS LAT, A.LONGITUDE AS LON
FROM (LOCATION_TBL NATURAL INNER JOIN DISTRICT) AS A CROSS JOIN (SELECT * FROM LOCATION_TBL WHERE DISTRICT_CODE = "1101") AS B
WHERE A.DISTRICT_CODE <> "1101"
ORDER BY (A.LATITUDE - B.LATITUDE) * (A.LATITUDE - B.LATITUDE) + (A.LONGITUDE - B.LONGITUDE) * (A.LONGITUDE - B.LONGITUDE) DESC