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'
inner join LOCATION_TBL kIJUN
on kIJUN.DISTRICT_CODE = '1101'
order by ABS(kIJUN.LATITUDE - LOCATION_TBL.LATITUDE)*ABS(kIJUN.LATITUDE - LOCATION_TBL.LATITUDE) + ABS(kIJUN.LONGITUDE - LOCATION_TBL.LONGITUDE)*ABS(kIJUN.LONGITUDE - LOCATION_TBL.LONGITUDE) desc, DISTRICT.DISTRICT_CODE asc