select 
    ltbl.district_code as CODE,
    district_name as NAME,
    ltbl.latitude as LAT,
    ltbl.longitude as LON
from location_tbl as ltbl 
left outer join (
select * from location_tbl 
where district_code='1101'
) as tmp 
inner join district as dtbl 
on ltbl.district_code=dtbl.district_code 
where ltbl.district_code<>'1101' 
order by sqrt(power(ltbl.latitude-tmp.latitude,2)+power(ltbl.longitude-tmp.longitude,2)) desc,code;