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 sqrt(pow(Abs(SUB.LATITUDE - MAIN.LATITUDE),2) + pow(Abs(SUB.LONGITUDE - MAIN.LONGITUDE),2)) DESC
          ,MAIN.DISTRICT_CODE ASC