SELECT player_id as Player, COUNT(DISTINCT(round_id)) AS Rounds, SUM(win) as Wins, SUM(loose) as Looses, SUM(bye) as Bye, SUM(sum) as Sum, SUM(gp_added) as GPSum FROM bg_r_p_sum WHERE game_id='149' AND round_id<'1061' GROUP BY player_id ORDER BY Looses ASC, Wins DESC, Player DESC, Rounds DESC

SELECT player_id as Player, COUNT(DISTINCT(round_id)) AS Rounds, SUM(win) as Wins, SUM(loose) as Looses, SUM(bye) as Bye, SUM(sum) as Sum, SUM(gp_added) as GPSum FROM bg_r_p_sum WHERE game_id='149' AND round_id<'1069' GROUP BY player_id ORDER BY Looses ASC, Wins DESC, Player DESC, Rounds DESC