WORLDWIDE TEAM CHALLENGE 2017
Status: Finished
Entry Fee 1300
Team Prize1: 50
Team Prize2: 30
Team Prize3: 20
Team Players: 5
Number of Looses: 3
WMB Value: 0
WRB Value: 0
List of Teams
| # | Team | Players |
|---|---|---|
| 1 | 
UK_TEAM_2 |
6 |
| 2 |
UK_TEAM_1 |
6 |
| 3 |
RUS_TEAM_1 |
6 |
| 4 |
RUS_TEAM_2 |
6 |
| 5 |
US_TEAM |
5 |
| 6 |
ARM_TEAM_1 |
7 |
| 7 |
ARM_TEAM_2 |
7 |
| 8 |
BUL_TEAM |
6 |
| 9 |
GEO_TEAM_1 |
6 |
| 10 |
GEO_TEAM_2 |
7 |
| 11 |
GER_TEAM |
5 |
| 12 |
UA_TEAM |
5 |
| 13 |
IS_TEAM |
7 |
| 14 |
IRAN_TEAM |
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='107' AND B.game_id='107' 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 |
|---|---|---|---|---|---|---|---|---|
| ARM_TEAM_2 | 10 | 8 | 2 | 0 | 0 | 0 | 9100 | 9100 |
| GEO_TEAM_1 | 10 | 7 | 3 | 0 | 0 | 0 | 5460 | 5460 |
| IRAN_TEAM | 8 | 4 | 3 | 1 | 0 | 0 | 3640 | 3640 |
| UK_TEAM_1 | 7 | 4 | 3 | 0 | 0 | 0 | ||
| GER_TEAM | 8 | 4 | 3 | 1 | 0 | 0 | ||
| IS_TEAM | 6 | 3 | 3 | 0 | 0 | 0 | ||
| BUL_TEAM | 6 | 3 | 3 | 0 | 0 | 0 | ||
| RUS_TEAM_1 | 5 | 2 | 3 | 0 | 0 | 0 | ||
| ARM_TEAM_1 | 5 | 2 | 3 | 0 | 0 | 0 | ||
| UA_TEAM | 5 | 2 | 3 | 0 | 0 | 0 | ||
| GEO_TEAM_2 | 4 | 1 | 3 | 0 | 0 | 0 | ||
| RUS_TEAM_2 | 4 | 1 | 3 | 0 | 0 | 0 | ||
| UK_TEAM_2 | 3 | 0 | 3 | 0 | 0 | 0 | ||
| US_TEAM | 3 | 0 | 3 | 0 | 0 | 0 |