SELECT
    logs.DISTRICT_CODE AS CODE,
    DISTRICT_NAME AS NAME,
    LATITUDE AS LAT,
    LONGITUDE AS LON
FROM (
    SELECT
        LOCATION_TBL.DISTRICT_CODE,
        LATITUDE,
        LONGITUDE,
        SQRT((LATITUDE - aa.lat1) *(LATITUDE - aa.lat1) + (LONGITUDE - aa.lon1) *(LONGITUDE - aa.lon1) ) AS distance
        -- aa.lat1,
        -- aa.lon1
    FROM
        LOCATION_TBL
    CROSS JOIN (
        SELECT
            LATITUDE AS lat1,
            LONGITUDE AS lon1
        FROM
            LOCATION_TBL
        WHERE
            DISTRICT_CODE = '1101'
    ) AS aa
) AS logs
LEFT OUTER JOIN
    DISTRICT
ON
    logs.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
WHERE
    logs.DISTRICT_CODE != '1101'
ORDER BY
    distance DESC,
    CODE ASC