select `prs_uniqClass`,`prs_teamPlayers`,`prs_score`,`prs_hndp`,`prs_total`,`prs_gameCounter`,MAX(prs_score) AS maxScore,MAX(prs_total) AS maxTotal,SUM(prs_total) AS total,MAX(prs_gamlevel) AS maxLevel from vPairsScores where prs_turId=165 and prs_gamlevel<=0 and prs_playersInTeam =2 GROUP by `prs_uniqClass`,`prs_gamlevel` order by prs_gamlevel,total DESCselect `prs_uniqClass`,`prs_teamPlayers`,`prs_score`,`prs_hndp`,`prs_total`,`prs_gameCounter`,MAX(prs_score) AS maxScore,MAX(prs_total) AS maxTotal,SUM(prs_total) AS total,MAX(prs_gamlevel) AS maxLevel from vPairsScores where prs_turId=165 and prs_gamlevel<=0 and prs_playersInTeam =3 GROUP by `prs_uniqClass`,`prs_gamlevel` order by prs_gamlevel,total DESC Polish Bowling Federation - Scoring

Mistrzostwa Polski Trójek - Wyniki

Eliminacje

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Jacek Kuciński/1540/
Mirosław Pająk/203/
Bożena Pająk/204/
2286
32
2318
190,50
2
Przemysław Nowak/2079/
Marek Murzynowski/639/
Marek Rybicki/2001/
2282
0
2282
190,17
3
Tomasz Drzewiecki/2066/
Patryk Preus/738/
Paweł Wierzbowski/749/
2250
0
2250
187,50
4
Adam Martin/169/
Tomasz Lutowski/860/
Krzysztof Strzałkowski/1316/
2177
0
2177
181,42
5
Damian Rychwicki/2390/
Mieczysław Polanisz/728/
Damian Majdecki/2389/
2171
0
2171
180,92
6
Adam Wójcik/1463/
Jacek Ratajczak/2878/
Przemysław Kantecki/1141/
2158
0
2158
179,83
7
Krzysztof Grzymkowski/1857/
Robert Chodorowski/2244/
Tomasz Żukowski/1854/
2093
0
2093
174,42
8
Łukasz Mastalerek/2877/
Łukasz Kudlinski/2391/
Jarek Mastalerek/2392/
1950
0
1950
162,50
9
Agnieszka Hulecka/2022/
Janusz Hulecki/2023/
Paweł Śmietana/2603/
1917
32
1949
159,75
powrót...
xxxx