select
    DISTRICT.DISTRICT_CODE as 'CODE',
    DISTRICT.DISTRICT_NAME as 'NAME',
    LOCATION_TBL.LATITUDE as 'LAT',
    LOCATION_TBL.LONGITUDE as 'LON'
from LOCATION_TBL
inner join DISTRICT
on LOCATION_TBL.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
and DISTRICT.DISTRICT_CODE != '1101'
order by ABS(43.044502 - LOCATION_TBL.LATITUDE) + ABS(141.354139 - LOCATION_TBL.LONGITUDE) desc, DISTRICT.DISTRICT_CODE asc