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=202 and prs_gamlevel<=1 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=202 and prs_gamlevel<=1 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

Półfinał

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Przemysław Nowak/2079/
Adam Martin/169/
Marek Rybicki/2001/
1643
1749
3392
182,56
2
Andrzej Walczak/2016/
Jakub Vlachovic/2942/
Honza Triska/2989/
1600
1662
3262
177,78
3
Andrzej Meronk/1616/
Kazimierz Rybicki/226/
Michał Rybicki/20/
1654
1578
3232
183,78
4
Bartłomiej Kachelski/2025/
Jacek Kuciński/1540/
Szymon Kręgielski/1461/
1572
1602
3174
174,67
5
Joanna Merklejn/783/
Przemysław Kantecki/1141/
Krzysztof Lenart/198/
1532
1593
3125
170,22
6
Tomasz Drzewiecki/2066/
Patryk Preus/738/
Paweł Wierzbowski/749/
1510
1578
3088
167,78
powrót...
xxxx