获取角色前50名总积分sql语句

 $sql2="select sum(fightvalue) AS total_fight from (SELECT fightvalue from {$table} WHERE pfrom_id={$pfrom_id} and server_id={$server_id} and lastlogintime>='{$last_login_day}' ORDER BY fightvalue DESC limit 50) tmp;";