SELECT l.DISTRICT_CODE AS CODE, d.DISTRICT_NAME AS NAME, l.LATITUDE AS LAT, l.LONGITUDE AS LON
FROM LOCATION_TBL AS l
INNER JOIN DISTRICT AS d ON l.DISTRICT_CODE = d.DISTRICT_CODE
WHERE l.DISTRICT_CODE <> '1101'
ORDER BY (
    POW(l.LATITUDE - (SELECT LATITUDE FROM LOCATION_TBL AS l2 WHERE l2.DISTRICT_CODE = '1101') ,2)
    +
    POW(l.LONGITUDE - (SELECT LONGITUDE FROM LOCATION_TBL AS l2 WHERE l2.DISTRICT_CODE = '1101') ,2)
) DESC, l.DISTRICT_CODE ASC;