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

Mecz o 3 miejsce

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Przemysław Nowak/2079/
Marek Rybicki/2001/
Alexander Langner/1849/
637
0
637
212,33
2
Jarosław Krzepkowski/752/
Andrzej Linke/129/
Michał Brachaniec/1585/
554
0
554
184,67
3
Krzysztof Lenart/198/
Joanna Merklejn/783/
Jarosław Pomykała/1051/
516
8
524
172,00
powrót...
xxxx