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

Mistrzostwa Polski Par - Wyniki

Squad 1

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Krzysztof Strzałkowski/1316/
Tomasz Grzeca/1249/
2407
0
2407
200,58
2
Przemysław Nowak/2079/
Marek Rybicki/2001/
2375
0
2375
197,92
3
Tomasz Lutowski/860/
Adam Martin/169/
2315
0
2315
192,92
4
Mieczysław Polanisz/728/
Damian Majdecki/2389/
2301
0
2301
191,75
5
Mirosław Pająk/203/
Bożena Pająk/204/
2204
48
2252
183,67
6
Kazimierz Rybicki/226/
Ryszard Korkowski/1546/
2211
0
2211
184,25
7
Damian Rychwicki/2390/
Łukasz Kudlinski/2391/
2144
0
2144
178,67
8
Magda Flisykowska/988/
Robert Ostaszyk/1622/
2085
48
2133
173,75
9
Krzysztof Grzymkowski/1857/
Robert Chodorowski/2244/
2104
0
2104
175,33
10
Tomasz Żukowski/1854/
Wiesław Frydrych/2051/
2097
0
2097
174,75
11
Anita Szulc/2243/
Lilla Frydrych/2050/
1986
96
2082
165,50
12
Adam Wójcik/1463/
Przemysław Kantecki/1141/
2056
0
2056
171,33
13
Joanna Merklejn/783/
Piotr Ryglowski/1074/
2004
48
2052
167,00
14
Roman Ochental/1797/
Szymon Kręgielski/1461/
2037
0
2037
169,75
15
Agnieszka Hulecka/2022/
Janusz Hulecki/2023/
1962
48
2010
163,50
16
Łukasz Mastalerek/2877/
Jarek Mastalerek/2392/
1825
0
1825
152,08
powrót...
xxxx