SELECT
t1.DISTRICT_CODE AS CODE,
DISTRICT_NAME AS NAME,
LATITUDE AS LAT,
LONGITUDE AS LON
FROM
LOCATION_TBL t1
INNER JOIN
DISTRICT t2
ON
t1.DISTRICT_CODE = t2.DISTRICT_CODE
CROSS JOIN
(SELECT
LATITUDE AS LAT_O,
LONGITUDE AS LON_O
FROM
LOCATION_TBL
WHERE
DISTRICT_CODE = '1101')
WHERE
t1.DISTRICT_CODE != '1101'
ORDER BY
(POWER(LATITUDE - LAT_O,2) + POWER(LONGITUDE-LON_O,2)) DESC,
t1.DISTRICT_CODE