SELECT
    L.district_code AS CODE
    , D.district_name AS NAME
    , L.latitude AS LAT
    , L.longitude AS LON 
FROM
    location_tbl L 
    INNER JOIN district D 
        ON L.district_code = D.district_code 
WHERE
    L.district_code <> '1101' 
ORDER BY
    ( 
        POW(LAT - 43.044502, 2) + POW(LON - 141.354139, 2)
    ) DESC
    , L.district_code ASC