select @rownum:=@rownum+1 as num, fin.* from (
    select rr.steamid, rr.name, sr.cmd_time  from (
        SELECT
            @dense_rank:=if(@prev_hid=s.steamid, @dense_rank + 1, 1) as dense_rank,
            @prev_hid:=s.steamid as steamid2,
            s.*
        FROM 227_27015 s,
        (SELECT @dense_rank:=0, @prev_hid:=0) var
        HAVING dense_rank=1
        ORDER BY s.steamid, s.`end` desc
    ) rr
    inner join (
        select z.steamid, sum(z.cmd_time) as cmd_time
        from 227_27015 z
        group by z.steamid
    ) sr ON rr.steamid=sr.steamid
) fin,
(select @rownum:=0) qq
order by fin.cmd_time desc
limit 25

select
    p.*,
    @rownum:=@rownum+1 as num
from (
    select
        rr.newid,
        rr.steamid,
        rr.name,
        sr.cmd_time,
        rr.end,
        sr.maxnewid
    from (
        select z.steamid, sum(z.cmd_time) as cmd_time, max(z.newid) as maxnewid
        from 227_27015 z
        group by z.steamid
        order by cmd_time desc, z.steamid 
        limit 25
    ) sr
    inner join 227_27015 rr ON sr.steamid=rr.steamid
    where rr.newid=sr.maxnewid
) p,
(SELECT @rownum:=0 ) var
order by p.cmd_time desc, p.steamid

select
	@rownum:=@rownum+1 as num,
    p.*
from (
    select
        rr.newid, rr.steamid, rr.name, sr.cmd_time, rr.end
    from (
        select
        	z.steamid, sum(z.cmd_time) as cmd_time, max(z.newid) as maxnewid
        from 227_27015 z
        group by z.steamid
        order by cmd_time desc, z.steamid 
        limit 0, 25
    ) sr
    inner join 227_27015 rr ON sr.maxnewid=rr.newid
) p,
(SELECT @rownum:=0 ) var
order by p.cmd_time desc, p.steamid