SELECT 
    LOCATION_TBL.DISTRICT_CODE AS CODE,
    DISTRICT.DISTRICT_NAME AS NAME,
    LOCATION_TBL.LATITUDE AS LAT,
    LOCATION_TBL.LONGITUDE AS LON
FROM LOCATION_TBL
LEFT JOIN DISTRICT ON DISTRICT.DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE
LEFT JOIN LOCATION_TBL AS LOCATION_1101
WHERE LOCATION_1101.DISTRICT_CODE = '1101'
    AND LOCATION_TBL.DISTRICT_CODE != '1101'
ORDER BY
    POW(LOCATION_1101.LATITUDE - LOCATION_TBL.LATITUDE, 2) +
        POW(LOCATION_1101.LONGITUDE - LOCATION_TBL.LONGITUDE, 2) DESC,
    LOCATION_TBL.DISTRICT_CODE;