SELECT
LT.DISTRICT_CODE CODE,
DT.DISTRICT_NAME NAME,
LT.LATITUDE LAT,
LT.LONGITUDE LON
FROM LOCATION_TBL LT
INNER JOIN DISTRICT DT
    ON DT.DISTRICT_CODE = LT.DISTRICT_CODE
    AND DT.DISTRICT_CODE != '1101'
CROSS JOIN LOCATION_TBL AS CRO
    ON CRO.DISTRICT_CODE = '1101'
ORDER BY
    (POW(CRO.LATITUDE - LT.LATITUDE, 2) + POW(CRO.LONGITUDE - LT.LONGITUDE, 2)) DESC
    , DT.DISTRICT_CODE ASC;