mysql 查询排序距离排序

if (!empty($sortBy)) {
            if ($sortBy == 'distance') {
                $orderSql = "(abs(e.longitude - $centerLongitude) + abs(e.latitude - $centerLatitude)) ASC ";
                $orderSql = "e.distance ASC ";
            } else if ($sortBy == 'edittime') {
                $orderSql = "e.edittime DESC ";
            } else if ($sortBy == 'addtime') {
                $orderSql = 'e.addtime DESC ';
            }
        }

SELECT e.id,e.title,e.userid,e.longitude,e.latitude,e.cat2icon,e.groupid,e.firmname,e.contact,e.addtime, e.salemodel, e.address, e.pic, e.isvip, st_distance (point(e.longitude, e.latitude), point(117.29397231570944,34.20784829452513))*111195 as distance FROM tp_equipment e WHERE e.isdel = ‘0’ AND e.authstatus IN (‘1’,‘0’) AND e.title LIKE ‘%车%’ ORDER BY isvip DESC,distance ASC,addtime DESC LIMIT 0,20