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<=2 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<=2 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

Finały

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Przemysław Nowak/2079/
Marek Murzynowski/639/
Marek Rybicki/2001/
609
0
609
203,00
2
Tomasz Drzewiecki/2066/
Patryk Preus/738/
Paweł Wierzbowski/749/
578
0
578
192,67
3
Jacek Kuciński/1540/
Mirosław Pająk/203/
Bożena Pająk/204/
538
8
546
179,33
4
Adam Martin/169/
Tomasz Lutowski/860/
Krzysztof Strzałkowski/1316/
503
0
503
167,67
powrót...
xxxx