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'
where LOCATION_TBL.PF_CODE = '01000'
order by ABS(43.044502 - LOCATION_TBL.LATITUDE)+ ABS(141.354139 - LOCATION_TBL.LONGITUDE) desc, DISTRICT.DISTRICT_CODE asc