SELECT  lt.DISTRICT_CODE AS CODE,
        DISTRICT_NAME AS NAME,
        LATITUDE AS LAT,
        LONGITUDE AS LON
FROM    LOCATION_TBL AS lt
JOIN    DISTRICT AS d
ON      lt.DISTRICT_CODE = d.DISTRICT_CODE
JOIN    (
        SELECT  LATITUDE AS B_LA, LONGITUDE AS B_LO
        FROM    LOCATION_TBL
        WHERE   DISTRICt_CODE = '1101'
        )
ORDER BY    sqrt(POW((B_LA - lt.LATITUDE), 2) + POW((B_LO - lt.LONGITUDE), 2)) DESC,
            lt.DISTRICT_CODE