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

Mistrzostwa Polski Par i Trójek - Wyniki

Squad 1 Trójki

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Roman Ochental/1797/
Jacek Kuciński/1540/
Marek Rybicki/2001/
2226
0
2226
185,50
2
Jan Charciarek/1225/
Maciej Kwiatkowski/1224/
Sebastian Kokott/1740/
2217
0
2217
184,75
3
Michał Brachaniec/1585/
Maciej Suwała/1562/
Lucyna Charęzińska/959/
2113
32
2145
176,08
4
Janusz Bryłkowski/146/
Robert Leszczyński/145/
Bartosz Bryłkowski/154/
2140
0
2140
178,33
5
Mieczysław Polanisz/728/
Jarosław Mastalerek/1871/
Grzegorz Polanisz/769/
2073
0
2073
172,75
6
Andrzej Bednarz/1481/
Andrzej Walczak/2016/
Zygmunt Kokurowski/1764/
2064
0
2064
172,00
7
Tomasz Chmiel/1466/
Sławomir Śliwiński/1591/
Izabela Daraż/1728/
2023
32
2055
168,58
8
Dariusz Olejniczak/1183/
Tomasz Olejniczak/1186/
Kamil Olejniczak/1185/
2033
0
2033
169,42
9
Paweł Żołnowski/1545/
Bartosz Szydłowski/1988/
Zbigniew Gorzycki/1979/
1845
0
1845
153,75
10
Marcin Klas/1977/
Piotr Wojciechowski/870/
Tadeusz Boruciński/869/
1843
0
1843
153,58
powrót...
xxxx