SELECT
 LOC.DISTRICT_CODE AS CODE
 , DIS.DISTRICT_NAME AS NAME
 , LOC.LATITUDE AS LAT
 , LOC.LONGITUDE AS LON
FROM DISTRICT AS DIS
INNER JOIN LOCATION_TBL AS LOC
ON LOC.DISTRICT_CODE = DIS.DISTRICT_CODE
AND DIS.DISTRICT_CODE != '1101'
CROSS JOIN LOCATION_TBL AS LOC1101
ON LOC1101.DISTRICT_CODE = '1101'
ORDER BY (POW(LOC1101.LATITUDE - LOC.LATITUDE, 2) + POW(LOC1101.LONGITUDE - LOC.LONGITUDE, 2)) DESC, DIS.DISTRICT_CODE ASC;