select 
L.DISTRICT_CODE as CODE
,DISTRICT_NAME as NAME
,LATITUDE as LAT
,LONGITUDE as LON
from 
LOCATION_TBL L
 join 
(select ifnull(LATITUDE,0) as LAT11,ifnull(LONGITUDE,0)  as LON11 ,PF_CODE from LOCATION_TBL where DISTRICT_CODE = '1101' ) A11
--on A11.PF_CODE=L.PF_CODE
left join DISTRICT D ON L.DISTRICT_CODE = D.DISTRICT_CODE
where L.DISTRICT_CODE <> '1101' 
order by 
SQRT((ifnull(LAT,0)-LAT11)*(ifnull(LAT,0)-LAT11)+(ifnull(LON,0)-LON11)*(ifnull(LON,0)-LON11)) desc
,L.DISTRICT_CODE asc