select
    DISTRICT_CODE as CODE,
    DISTRICT_NAME as NAME,
    LATITUDE as LAT,
    LONGITUDE as LON
from
    location_tbl
order by
    ACOS(COS(RADIANS((select lat from location_tbl where district_code = "1101"))) * COS(RADIANS(LAT)) * COS(RADIANS(LON) - RADIANS((select lon from location_tbl where district_code = "1101")))+ SIN(RADIANS((select lat from location_tbl where district_code = "1101"))) * SIN(RADIANS(LAT)) desc,
    code asc;