Manual round End
Status: Started
Entry Fee 100
Finish Round: 4
List of Players
| # | Nick | First | Last |
|---|---|---|---|
| 1 | 
Asatiani |
Mamuka | Asatiani |
| 2 |
Bozkurt |
Ufuk | Bozkurt |
| 3 |
Osovskiy |
Konstantin | Osovskiy |
| 4 |
Danielyan |
Karlen | Danielyan |
| 5 |
Yazawa |
Akiko | Yazawa |
| 6 |
Petrosyan |
Levon | Petrosyan |
| 7 |
Solodukhin |
Alexander | Solodukhin |
| 8 |
Mirijanyan |
Eduard | Mirijanyan |
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 = '1491') 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='161' GROUP BY BGRP.player_id ORDER BY SUMPLUSGP DESC, GPSum DESC, Player DESC, Rounds DESC
Summary
| Player | Round | Wins | Looses | Bye | Total Score |
|---|---|---|---|---|---|
| Yazawa | 2 | 1 | 1 | 0 | 121 |
| Danielyan | 2 | 2 | 0 | 0 | 104 |
| Mirijanyan | 2 | 2 | 0 | 0 | 104 |
| Asatiani | 2 | 1 | 1 | 0 | 102 |
| Bozkurt | 2 | 1 | 1 | 0 | 100 |
| Osovskiy | 2 | 1 | 1 | 0 | 100 |
| Petrosyan | 2 | 0 | 2 | 0 | 98 |
| Solodukhin | 2 | 0 | 2 | 0 | 79 |
Round 1
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 = '1410') 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='161' AND BGRP.round_id<'1410' GROUP BY BGRP.player_id ORDER BY SUMPLUSGP DESC, GPSum DESC, Player DESC, Rounds DESC
Round 2
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 = '1491') 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='161' AND BGRP.round_id<'1491' GROUP BY BGRP.player_id ORDER BY SUMPLUSGP DESC, GPSum DESC, Player DESC, Rounds DESC
Result
| Player | Round | Wins | Looses | Bye | Total Score |
|---|---|---|---|---|---|
| Bozkurt | 1 | 1 | 0 | 0 | 101 |
| Danielyan | 1 | 1 | 0 | 0 | 101 |
| Osovskiy | 1 | 1 | 0 | 0 | 101 |
| Mirijanyan | 1 | 1 | 0 | 0 | 101 |
| Solodukhin | 1 | 0 | 1 | 0 | 99 |
| Asatiani | 1 | 0 | 1 | 0 | 99 |
| Petrosyan | 1 | 0 | 1 | 0 | 99 |
| Yazawa | 1 | 0 | 1 | 0 | 99 |