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=104 and prs_gamlevel<=6 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=104 and prs_gamlevel<=6 and prs_playersInTeam =3 GROUP by `prs_uniqClass`,`prs_gamlevel` order by prs_gamlevel,total DESC Polish Bowling Federation - Scoring

MPPiT Opole FitLife - Wyniki

Półfinał Trójek

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Jacek Kuciński/1540/
Ryszard Korkowski/1546/
Krzysztof Olesiński/792/
600
0
600
200,00
2
Jacek Skorupa/1063/
Marek Murzynowski/639/
Mateusz Kacprowicz/984/
542
0
542
180,67
3
Michał Świtalski/950/
Marek Rybicki/2001/
Przemysław Nowak/2079/
500
0
500
166,67
powrót...
xxxx