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`
                                                WHERE `start` >= 0 AND 1567774177 >= `end` 
						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='[U:1:54634231]'