WORLDWIDE TEAM CHALLENGE
Status: Finished
Entry Fee 1300
Team Prize1: 650
Team Prize2: 390
Team Prize3: 260
Team Players: 5
Number of Looses: 3
WMB Value: 0
WRB Value: 0
List of Teams
| # | Team | Players |
|---|---|---|
| 1 | 
UA_TEAM |
6 |
| 2 |
ARM_TEAM_1 |
7 |
| 3 |
DEN_TEAM |
5 |
| 4 |
RUS_TEAM_2 |
7 |
| 5 |
RUS_TEAM_1 |
6 |
| 6 |
GEO_TEAM_1 |
6 |
| 7 |
US_TEAM |
5 |
| 8 |
GER_TEAM |
5 |
| 9 |
JAP_TEAM |
6 |
| 10 |
UK_TEAM_2 |
6 |
| 11 |
UK_TEAM_1 |
5 |
| 12 |
GER_TEAM_EX |
5 |
| 13 |
GEO_TEAM_2 |
7 |
| 14 |
ARM_TEAM_2 |
5 |
| 15 |
World |
5 |
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='79' AND B.game_id='79' 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 |
|---|---|---|---|---|---|---|---|---|
| UK_TEAM_1 | 11 | 9 | 2 | 0 | 0 | -12665250 | 12675000 | 9750 |
| RUS_TEAM_2 | 11 | 7 | 3 | 1 | 0 | -7599150 | 7605000 | 5850 |
| RUS_TEAM_1 | 9 | 5 | 3 | 1 | 0 | -5066100 | 5070000 | 3900 |
| GER_TEAM | 8 | 4 | 3 | 1 | 0 | -5066100 | ||
| GEO_TEAM_1 | 6 | 3 | 3 | 0 | 0 | 0 | ||
| ARM_TEAM_2 | 6 | 3 | 3 | 0 | 0 | 0 | ||
| UA_TEAM | 7 | 3 | 3 | 1 | 0 | 0 | ||
| GEO_TEAM_2 | 5 | 2 | 3 | 0 | 0 | 0 | ||
| GER_TEAM_EX | 6 | 2 | 3 | 1 | 0 | 0 | ||
| JAP_TEAM | 5 | 2 | 3 | 0 | 0 | 0 | ||
| ARM_TEAM_1 | 6 | 2 | 3 | 1 | 0 | 0 | ||
| US_TEAM | 4 | 1 | 3 | 0 | 0 | 0 | ||
| DEN_TEAM | 4 | 1 | 3 | 0 | 0 | 0 | ||
| World | 3 | 0 | 3 | 0 | 0 | 0 | ||
| UK_TEAM_2 | 4 | 0 | 3 | 1 | 0 | 0 |