SELECT 
    MAIN.DISTRICT_CODE AS CODE
    ,D.DISTRICT_NAME AS NAME
    ,MAIN.LATITUDE AS LAT
    ,MAIN.LONGITUDE AS LON
  FROM LOCATION_TBL AS MAIN
INNER JOIN DISTRICT AS D ON MAIN.DISTRICT_CODE = D.DISTRICT_CODE
LEFT OUTER JOIN LOCATION_TBL AS SUB ON SUB.DISTRICT_CODE = '1101' 
 WHERE MAIN.DISTRICT_CODE <> '1101' 
 ORDER BY Abs(SUB.LATITUDE - MAIN.LATITUDE) + Abs(SUB.LONGITUDE - MAIN.LONGITUDE) DESC
          ,MAIN.DISTRICT_CODE ASC