SELECT
    DISTRICT.DISTRICT_CODE AS CODE,
    DISTRICT.DISTRICT_NAME AS NAME,
    SOURCE.LATITUDE AS LAT,
    SOURCE.LONGITUDE AS LON
FROM 
    LOCATION_TBL AS
    SOURCE
CROSS JOIN
    LOCATION_TBL AS
    TARGET ON
    TARGET.DISTRICT_CODE = '1101'
INNER JOIN
    DISTRICT ON
    DISTRICT.DISTRICT_CODE = SOURCE.DISTRICT_CODE
WHERE
    SOURCE.DISTRICT_CODE <> '1101'
ORDER BY
    SQRT(POW(SOURCE.LATITUDE - TARGET.LATITUDE, 2) + POW(SOURCE.LONGITUDE - TARGET.LONGITUDE, 2)) DESC,
    DISTRICT.DISTRICT_CODE ASC