select 
  CODE
  , NAME
  , LAT
  , LON
from
  (
    select 
      LT.DISTRICT_CODE as CODE
      , DISTRICT_NAME as NAME
      , LATITUDE as LAT
      , LONGITUDE as LON
      , '1101' as TMP
    from
      LOCATION_TBL LT
      left join DISTRICT D
      on LT.DISTRICT_CODE = D.DISTRICT_CODE
    where 
      LT.DISTRICT_CODE <> '1101'
  ) as T1
  left join LOCATION_TBL T2
  on T1.TMP = T2.DISTRICT_CODE
order by 
  -- (T1.LON - T2.LONGITUDE) * (T1.LON - T2.LONGITUDE) + (T1.LAT - T2.LATITUDE) * (T1.LAT - T2.LATITUDE) desc
    6371 * ACOS( 
      COS(RADIANS(T1.LAT)) * COS(RADIANS(T2.LATITUDE)) * COS(RADIANS(T2.LONGITUDE) - RADIANS(T1.LON))
       + SIN(RADIANS(T1.LAT)) * SIN(RADIANS(T2.LATITUDE))
    ) desc
  , DISTRICT_CODE
;