team test
Status: Finished
Entry Fee 100
Team Prize1: 500
Team Prize2: 200
Team Prize3: 100
Team Players: 3
Number of Looses: 3
WMB Value: 10
WRB Value: 10
List of Teams
| # | Team | Players |
|---|---|---|
| 1 | 
UA_TEAM |
4 |
| 2 |
ARM_TEAM_1 |
4 |
| 3 |
GER_TEAM |
4 |
| 4 |
LAT_TEAM |
4 |
| 5 |
US_TEAM |
4 |
| 6 |
JAP_TEAM |
4 |
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='166' AND B.game_id='166' GROUP BY A.player_id ORDER BY Looses ASC, Wins DESC, WINAM DESC, Player DESC, Rounds DESC
Summary
| Team | Round | Wins | Looses | Bye | Total WRBs | Total WMBs | Prize | Total Score |
|---|---|---|---|---|---|---|---|---|
| US_TEAM | 7 | 6 | 0 | 1 | 60 | -296770 | 300000 | 3290 |
| LAT_TEAM | 7 | 4 | 3 | 0 | 40 | -118680 | 120000 | 1360 |
| ARM_TEAM_1 | 6 | 3 | 3 | 0 | 30 | -59290 | 60000 | 740 |
| JAP_TEAM | 5 | 1 | 3 | 1 | 10 | -59290 | 60 | |
| GER_TEAM | 4 | 1 | 3 | 0 | 10 | 30 | 40 | |
| UA_TEAM | 3 | 0 | 3 | 0 | 0 | 0 |