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=172 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=172 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
Kazimierz Rybicki/226/
Michał Rybicki/20/
453
0
453
226,50
2
Alessandro Silletti/16/
Tomasz Janicki/194/
426
0
426
213,00
3
Paweł Bielski/626/
Kuba Gapiński/787/
390
0
390
195,00
4
Przemysław Nowak/2079/
Marek Rybicki/2001/
330
0
330
165,00
powrót...
xxxx