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=207 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=207 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 Par - Wyniki

Półfinał

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Mikołaj Czarnecki/3014/
Roland Muras/1756/
1841
1692
3533
230,13
2
Dominik Chomicz/3030/
Robert Chodorowski/2244/
1782
1596
3378
222,75
3
Przemysław Nowak/2079/
Marek Rybicki/2001/
1678
1556
3234
209,75
4
Daniel Głuchowski/2331/
Dariusz Rojek/2627/
1558
1588
3146
194,75
5
Jarosław Pomykała/1051/
Krzysztof Baniewski/2296/
1540
1576
3116
192,50
6
Mateusz Boś/1068/
Krzysztof Lenart/198/
1471
1584
3055
183,88
7
Bożena Pająk/204/
Mirosław Pająk/203/
1446
1600
3046
180,75
8
Katarzyna Dominiak/1841/
Przemysław Sowiński/2120/
1461
1560
3021
182,63
9
Marcin Wojtaszczyk/1538/
Robert Gozdowski/2793/
1472
1532
3004
184,00
10
Andrzej Meronk/1616/
Kazimierz Rybicki/226/
1400
1564
2964
175,00
11
Radosław Zioło/3027/
Witold Czarnecki/3020/
1414
1536
2950
176,75
powrót...
xxxx