带序号的mysql查询

SELECT *,(@rowno:=@rowno+1) as ranking   
FROM
 (    SELECT u.*,cc.answerNumTotal,cc.rightNumTotal,cc.answerTimeTotal,cc.maxBarrierNum
      FROM p_user u 
      LEFT JOIN (  
          SELECT SUM(answerNum) answerNumTotal,SUM(rightNum) rightNumTotal,SUM(answerTime) answerTimeTotal,MAX(barrierNum) maxBarrierNum,a.userId 
          FROM p_answer_stats a  GROUP BY a.userId  ) cc ON cc.userId=u.userId 
          ) uu ,(select (@rowno:=0)
  ) aaa  where 1=1 order by uu.totalScore desc