SELECT A.player_id as Player, COUNT(DISTINCT(A.round_id)) AS Rounds, SUM(A.win) as Wins, SUM(A.loose) as Looses, SUM(A.bye) as Bye, B.win_amount as WINAM FROM bg_r_p_sum AS A LEFT JOIN bg_player_game AS B ON A.player_id = B.player_id WHERE A.game_id='144' AND B.game_id='144' GROUP BY A.player_id ORDER BY Looses ASC, Wins DESC, WINAM DESC, Player DESC, Rounds DESC