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, SUM(BGRP.sum) as Sum, 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 = '1586') 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='164' AND BGRP.round_id<'1586' GROUP BY BGRP.player_id ORDER BY SUMPLUSGP DESC, GPSum DESC, Player DESC, Rounds DESC
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2807
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2810
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2813
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Warning: A non-numeric value encountered in /mnt/web109/b0/33/5108633/htdocs/TRIPLE/functions.inc.php on line 2817
Result
Player | Round | Wins | Looses | Bye |
Total Score |
michy | 1 |
1 |
0 |
0 |
83 |
Cem Yavuz | 1 |
1 |
0 |
0 |
82 |
Duval | 1 |
1 |
0 |
0 |
81 |
Tudose | 1 |
1 |
0 |
0 |
80 |
Findikoglu | 1 |
1 |
0 |
0 |
78 |
Malas | 1 |
1 |
0 |
0 |
76 |
Mochy | 1 |
0 |
1 |
0 |
20(70) |
Kareli | 1 |
0 |
1 |
0 |
19(69) |
Garal | 1 |
0 |
1 |
0 |
18(68) |
Metskhvarishvili | 1 |
0 |
1 |
0 |
17(67) |
Mayer | 1 |
0 |
0 |
1 |
50 |
Poxosyan | 1 |
0 |
1 |
0 |
24 |
Simon | 1 |
0 |
1 |
0 |
22 |