WORLDWIDE TEAM CHALLENGE 2017
Status: Finished
Entry Fee 1300
Team Prize1: 50
Team Prize2: 30
Team Prize3: 20
Team Players: 5
Finish Round: 0
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 BGRP.player_id as Player, COUNT(DISTINCT(BGRP.round_id)) AS Rounds, SUM(BGRP.win) as Wins, SUM(BGRP.loose) as Looses, SUM(BGRP.bye) as Bye, IF(SUM(BGRP.sum)> 0 ,SUM(BGRP.sum),0) as TOTAL, SUM(BGRP.gp_added) as GPSum, (SUM(BGRP.sum)+(SUM(BGRP.gp_added)*GAMES.game_amount)) as SUMPLUSGP, (SELECT gp_added FROM bg_r_p_sum WHERE player_id = Player
AND round_id = '845') AS GP FROM bg_r_p_sum as BGRP LEFT JOIN bg_games as GAMES on GAMES.game_id = BGRP.game_id WHERE BGRP.game_id='107' GROUP BY BGRP.player_id ORDER BY TOTAL DESC, GPSum DESC, Player DESC, Rounds DESC
Warning: Use of undefined constant current_game - assumed 'current_game' (this will throw an Error in a future version of PHP) in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 9163
Warning: Use of undefined constant current_game - assumed 'current_game' (this will throw an Error in a future version of PHP) in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 9165
Warning: Use of undefined constant current_game - assumed 'current_game' (this will throw an Error in a future version of PHP) in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 9167
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2780
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2785
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2789
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2797
Summary
| Team | Round | Wins | Looses | Bye | Total Score |
|---|---|---|---|---|---|
| IRAN_TEAM | 8 | 4 | 3 | 1 | 0 |
| IS_TEAM | 6 | 3 | 3 | 0 | 0 |
| GEO_TEAM_2 | 4 | 1 | 3 | 0 | 0 |
| UK_TEAM_1 | 7 | 4 | 3 | 0 | 0 |
| UK_TEAM_2 | 3 | 0 | 3 | 0 | 0 |
| US_TEAM | 3 | 0 | 3 | 0 | 0 |
| GEO_TEAM_1 | 10 | 7 | 3 | 0 | 0 |
| RUS_TEAM_1 | 5 | 2 | 3 | 0 | 0 |
| ARM_TEAM_1 | 5 | 2 | 3 | 0 | 0 |
| ARM_TEAM_2 | 10 | 8 | 2 | 0 | 0 |
| RUS_TEAM_2 | 4 | 1 | 3 | 0 | 0 |
| BUL_TEAM | 6 | 3 | 3 | 0 | 0 |
| GER_TEAM | 8 | 4 | 3 | 1 | 0 |
| UA_TEAM | 5 | 2 | 3 | 0 | 0 |