SELECT cc.rank_cmd, cc.value_cmd_time, cc.rank_ct, cc.value_ct_time, cc.rank_t, cc.value_t_time FROM 
( 
	SELECT @i:=@i+1 as rank_cmd, value_cmd_time, rank_ct, value_ct_time, rank_t, value_t_time, steamid FROM 
	( 
		SELECT * FROM 
		( 
			SELECT value_cmd_time, @j:=@j+1 as rank_ct, value_ct_time, rank_t, value_t_time, steamid FROM 
			( 
				SELECT * FROM 
				( 
					SELECT value_cmd_time, value_ct_time, @k:=@k+1 as rank_t, value_t_time, c.steamid FROM 
					( 
						SELECT steamid, SUM(cmd_time) value_cmd_time, SUM(ct_time) value_ct_time, SUM(t_time) value_t_time FROM table1 GROUP BY steamid ORDER BY 4 DESC 
					) c, (select @i:=0, @j:=0, @k:=0) AS z 
				) c2 ORDER BY c2.value_ct_time DESC 
			) c3 
		) c4 ORDER BY c4.value_cmd_time DESC 
	) c5 
) cc WHERE cc.steamid='[123]'