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=78 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=78 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 i Trójek - Wyniki

Półfinał Par

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Adam Martin/169/
Tomasz Lutowski/860/
412
0
412
206,00
2
Paweł Bielski/626/
Marek Przezpolewski/17/
411
0
411
205,50
3
Dawid Kantyka/1187/
Adam Błaszczak/803/
377
0
377
188,50
4
Bożena Pająk/204/
Joanna Merklejn/783/
348
0
348
174,00
5
Izabela Daraż/1728/
Monika Pieszak/1893/
312
0
312
156,00
6
Lucyna Charęzińska/959/
Małgorzata Kiedrowska/136/
310
0
310
155,00
7
Anna Bargańska/1910/
Natalia Dragan/1911/
189
0
189
94,50
powrót...
xxxx