mySql中的序号排序问题

1.将所要序号的查询的结果整合成一张表 b，

再 SELECT  @rownum:=@rownum+1 as rn,b.* from (select @rownum:=0) r,(原来的查询语句) as b

示例：

SELECT  @rownum:=@rownum+1 as rn,b.* 
FROM (select @rownum:=0) r,(
SELECT
operate_score_detSELECT  @rownum:=@rownum+1 as rn,b.* 
FROM (select @rownum:=0) r,(
SELECT
operate_score_detail.id,
admin_info.NAME AS add_admin_name,
operate_group.group_name,
admin_info2.NAME AS belong_to_admin_name 
FROM
    `o2o_operate_score_detail` `operate_score_detail`
    LEFT JOIN o2o_admin_info AS admin_info ON admin_info.id = operate_score_detail.add_admin_id
    LEFT JOIN o2o_operate_group AS operate_group ON operate_group.id = operate_score_detail.group_id
    LEFT JOIN o2o_admin_info AS admin_info2 ON admin_info2.id = operate_score_detail.admin_id 
WHERE
    operate_score_detail.detail_type <> 4 
ORDER BY
    operate_score_detail.id DESC 
    LIMIT 20) AS b ;
    ail.id,
admin_info.NAME AS add_admin_name,
operate_group.group_name,
admin_info2.NAME AS belong_to_admin_name 
FROM
    `o2o_operate_score_detail` `operate_score_detail`
    LEFT JOIN o2o_admin_info AS admin_info ON admin_info.id = operate_score_detail.add_admin_id
    LEFT JOIN o2o_operate_group AS operate_group ON operate_group.id = operate_score_detail.group_id
    LEFT JOIN o2o_admin_info AS admin_info2 ON admin_info2.id = operate_score_detail.admin_id 
WHERE
    operate_score_detail.detail_type <> 4 
ORDER BY
    operate_score_detail.id DESC 
    LIMIT 20) AS b ;