mysql緯度に基づいて距離でソート

 
    
    SELECT*,ROUND(6378.138 * 2 * ASIN(SQRT(POW(SIN((#{lat} * PI() / 180 - latitude * PI() / 180
    ) / 2),2) + COS(40.0497810000 * PI() / 180) * COS(latitude * PI() / 180) * POW(
    SIN(
    (
    #{long} * PI() / 180 - longitude * PI() / 180
    ) / 2),2))) * 1000
    ) AS dis
    FROM
    sj_shop_info
    ORDER BY
    dis DESC