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

Akademicki Puchar Polski Par - Wyniki

eliminacje par

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Szymon Pawluszak/922/
Tomasz Kaliszuk/2160/
1138
0
1138
189,67
2
Adam Wójcik/1463/
Robert Ostaszyk/1622/
1105
0
1105
184,17
3
Krystian Krystkiewicz/2332/
Marcin Ciarkowski/1194/
1000
0
1000
166,67
4
Arkadiusz Trochowski/2653/
Mateusz Kapral/2688/
926
0
926
154,33
5
Piotr Niezgoda/2159/
Szymon Karolewicz/2654/
837
0
837
139,50
6
Patryk Matusiak/2320/
Mateusz Stasiak/2321/
826
0
826
137,67
7
Anna Kociach/2681/
Artur Flasiński/2633/
756
30
786
126,00
8
Justyna Kiełbasa/2657/
Krzysztof Kaczmarek/2636/
734
30
764
122,33
9
Dominika Sokołowska/2644/
Julia Delmanowicz/2643/
699
60
759
116,50
10
Maciej Kołuda/2655/
Jan Wiktor Meissner/2667/
721
0
721
120,17
powrót...
xxxx