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

MPPiT Opole FitLife - Wyniki

Eliminacje Trójek

Wynik dla par

Lp
Grupa graczy
Wynik
Hndp
Total
Śr
1
Jacek Skorupa/1063/
Marek Murzynowski/639/
Mateusz Kacprowicz/984/
2370
0
2370
197,50
2
Michał Świtalski/950/
Marek Rybicki/2001/
Przemysław Nowak/2079/
2345
0
2345
195,42
3
Jacek Kuciński/1540/
Ryszard Korkowski/1546/
Krzysztof Olesiński/792/
2334
0
2334
194,50
4
Tomasz Olejniczak/1186/
Tonio Antuszewicz/44/
Adam Błaszczak/803/
2317
0
2317
193,08
5
Tomasz Janicki/194/
Karol Kwiatkowski/929/
Dawid Szpański/197/
2302
0
2302
191,83
6
Adam Martin/169/
Tomasz Lutowski/860/
Patryk Preus/738/
2238
0
2238
186,50
7
Zbigniew Strzelecki/2076/
Natalia Martin/29/
Zygmunt Kokurowski/1764/
2158
32
2190
179,83
8
Michał Brachaniec/1585/
Dariusz Matyśniak/1029/
Jarosław Krzepkowski/752/
2190
0
2190
182,50
9
Katarzyna Zdebik/2092/
Lucyna Charęzińska/959/
Dariusz Olejniczak/1183/
2095
64
2159
174,58
10
Piotr Wojciechowski/870/
Andrzej Meronk/1616/
Tadeusz Boruciński/869/
2158
0
2158
179,83
11
Andrzej Walczak/2016/
Grzegorz Kępiński/1768/
Alexander Langner/1849/
2146
0
2146
178,83
12
Piotr Mital/1590/
Sławomir Śliwiński/1591/
Michał Wiechno/2014/
2075
0
2075
172,92
13
Mariusz Kowalik/1939/
Ryszard Siwak/997/
Mateusz Pabiniak/1751/
1871
0
1871
155,92
powrót...
xxxx