RBI-test-Looses2
Status: Started
Option: RBI
Entry Fee 1500
Number of Looses: 2
First Prize: 12750 (50%)
Second Prize: 7650 (30%)
Third Prize: 2550 (10%)
List of Players
| # | Nick | First | Last |
|---|---|---|---|
| 1 | 
Wiebusch |
Norbert | Wiebusch |
| 2 |
Kaplanski |
Igor | Kaplanski |
| 3 |
Gochan |
Hilmi | Göçhan |
| 4 |
Bernaba |
Toni | Bernaba |
| 5 |
Bellici |
Fatih | Bellici |
| 6 |
Norreen |
Claes Saleh | Norreen |
| 7 |
Fischer |
Ralf | Fischer |
| 8 |
Avdis |
Giorgos | Avdis |
| 9 |
Vincent |
Alexis | Vincent |
| 10 |
Gesgeburyan |
Karen | Gesgeburyan |
| 11 |
Plesec |
Damjan | Plesec |
| 12 |
Froeschl |
Konrad | Froeschl |
| 13 |
VSonnabend |
Volker | Sonnabend |
| 14 |
Zaoral |
Pavel | Zaoral |
| 15 |
Hovhannisyan |
Hayk | Hovhannisyan |
| 16 |
elza |
Eva | Zizkova |
| 17 |
Lachnit_Winter |
Georg | Lachnit-Winter |
SELECT player_id as Player, COUNT(DISTINCT(round_id)) AS Rounds, SUM(win) as Wins, SUM(loose) as Looses, SUM(bye) as Bye, SUM(sum) as Sum, SUM(gp_added) as GPSum FROM bg_r_p_sum WHERE game_id='154' GROUP BY player_id ORDER BY Looses ASC, Wins DESC, Player DESC, Rounds DESC
Summary
| Player | Round | Wins | Looses | Bye |
|---|---|---|---|---|
| Bellici | 1 | 1 | 0 | 0 |
| Norreen | 1 | 1 | 0 | 0 |
| Hovhannisyan | 1 | 1 | 0 | 0 |
| Lachnit_Winter | 1 | 1 | 0 | 0 |
| Froeschl | 1 | 1 | 0 | 0 |
| Fischer | 1 | 1 | 0 | 0 |
| Zaoral | 1 | 1 | 0 | 0 |
| Vincent | 1 | 1 | 0 | 0 |
| VSonnabend | 1 | 0 | 0 | 1 |
| Gochan | 1 | 0 | 1 | 0 |
| Gesgeburyan | 1 | 0 | 1 | 0 |
| Bernaba | 1 | 0 | 1 | 0 |
| Wiebusch | 1 | 0 | 1 | 0 |
| Kaplanski | 1 | 0 | 1 | 0 |
| Avdis | 1 | 0 | 1 | 0 |
| elza | 1 | 0 | 1 | 0 |
| Plesec | 1 | 0 | 1 | 0 |
Round 1
SELECT player_id as Player, COUNT(DISTINCT(round_id)) AS Rounds, SUM(win) as Wins, SUM(loose) as Looses, SUM(bye) as Bye, SUM(sum) as Sum, SUM(gp_added) as GPSum FROM bg_r_p_sum WHERE game_id='154' AND round_id<'1288' GROUP BY player_id ORDER BY Looses ASC, Wins DESC, Player DESC, Rounds DESC