with TBL as (
    select * from LOCATION_TBL
    where DISTRICT_CODE  = '1101'
    )
select 
  c.DISTRICT_CODE as CODE
  ,e.DISTRICT_NAME as NAME
  , c.LATITUDE as LAT
  , c.LONGITUDE as LON
from 
    LOCATION_TBL c
inner join 
    (
        select
          a.*
          , ( 
            6371 * ACOS( 
              COS(RADIANS(b.LATITUDE)) * COS(RADIANS(a.LATITUDE))
              * COS(RADIANS(a.LONGITUDE) - RADIANS(b.LONGITUDE))
               + SIN(RADIANS(b.LATITUDE)) * SIN(RADIANS(a.LATITUDE))
            )
          ) as DISTANCE 
        from
            LOCATION_TBL a
        cross join TBL b
    ) d
    on c.PF_CODE = d.PF_CODE 
    and c.DISTRICT_CODE = d.DISTRICT_CODE 
inner join DISTRICT e
    on c.DISTRICT_CODE  = e.DISTRICT_CODE 
where c.DISTRICT_CODE  != '1101'
order by
    DISTANCE desc
    ,c.DISTRICT_CODE