select LOCATION_TBL.DISTRICT_CODE as CODE, DISTRICT.DISTRICT_NAME as NAME, LATITUDE as LAT, LONGITUDE as LON from LOCATION_TBL
    left outer join DISTRICT on CODE = DISTRICT.DISTRICT_CODE 
    where CODE != "1101"
    order by 
        (
            select POW(LAT-i.LATITUDE, 2) + POW(LON-i.LONGITUDE, 2)
            from LOCATION_TBL as i
            where DISTRICT_CODE = "1101"
        ) desc,
        LOCATION_TBL.DISTRICT_CODE asc;