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

Półfinał

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Kuba Piotrowski/832/
Alessandro Silletti/16/
Tomasz Janicki/194/
608
0
608
202,67
2
Emil Polanisz/615/
Tymon Ciećkiewicz/856/
Daniel Wiśniewski/811/
561
0
561
187,00
3
Marek Kozłowiec/2510/
Piotr Prokurat/2775/
Dariusz Rojek/2627/
553
0
553
184,33
powrót...
xxxx