SELECT 
S.DISTRICT_CODE AS CODE,
D.DISTRICT_NAME AS NAME,
S.LATITUDE AS LAT,
S.LONGITUDE  AS LON
FROM
(
SELECT
P.DISTRICT_CODE ,
P.LATITUDE,
P.LONGITUDE ,
 ( 
6371 * ACOS( 
 COS(RADIANS(A.LAT)) * COS(RADIANS(P.LATITUDE)) *
 COS(RADIANS(P.LONGITUDE) - RADIANS(A.LON))
  + SIN(RADIANS(35.663729)) * SIN(RADIANS(P.LATITUDE))
)
 ) AS DISTANCE 
FROM
LOCATION_TBL AS P

LEFT JOIN
(SELECT 
LATITUDE AS LAT,
LONGITUDE AS LON
FROM LOCATION_TBL
WHERE
DISTRICT_CODE  ='1101'
) AS A 

WHERE
P.DISTRICT_CODE  <> '1101'
) AS S
LEFT JOIN DISTRICT AS D ON
D.DISTRICT_CODE = S.DISTRICT_CODE
ORDER BY 
DISTANCE DESC, S.DISTRICT_CODE ASC