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=221 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=221 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ły

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Tomasz Janicki/194/
Alessandro Silletti/16/
1438
1600
3038
179,75
2
Sebastian Jaskulski/1613/
Aleks Szczepaniak/2741/
1361
1460
2821
170,13
3
Patryk Preus/738/
Michał Gebauer/2301/
1414
1396
2810
176,75
4
Paweł Bielski/626/
Emil Polanisz/615/
1390
1404
2794
173,75
5
Dawid Kantyka/1187/
Patryk Antosiak/3357/
1417
1360
2777
177,13
6
Jarosław Czuła/1759/
Krzysztof Czuła/2998/
1360
1404
2764
170,00
7
Krzysztof Grzymkowski/1857/
Tomasz Żukowski/1854/
1377
1380
2757
172,13
8
Bożena Pająk/204/
Mirosław Pająk/203/
1279
1420
2699
159,88
9
Michał Dąbrowski/2526/
Marek Grabas/3334/
1280
1408
2688
160,00
10
Wiesław Frydrych/2051/
Lilla Frydrych/2050/
1222
1448
2670
152,75
powrót...
xxxx