Statistiky brankářů
SELECT stats_suma.*, hrac.jmeno, hrac.prijmeni, hrac.post FROM stats_suma INNER JOIN hrac ON stats_suma.id_hrac = hrac.id WHERE stats_suma.sezona='2017' AND hrac.post='B' ORDER BY stats_suma.uspesnost DESC, stats_suma.priorita DESC, stats_suma.prumer DESC, stats_suma.prumer ASC, stats_suma.minuty DESC, stats_suma.strely DESC LIMIT 5tým | # | Jméno a příjmení | Z | Min | Stř | Zás | Ink | Prů | Úsp | SO | A | TM | |
1. | ![]() | 2 | Patrik ŠVANČARA | 4 | 214 | 23 | 0 | 23 | 6,45 | 0,00 | 0 | 0 | 0 |
2. | ![]() | 31 | Marek MICKA | 3 | 150 | 16 | 0 | 16 | 6,40 | 0,00 | 0 | 0 | 0 |
3. | ![]() | 30 | Teemu RIIHIMÄKI | 3 | 160 | 16 | 0 | 16 | 6,00 | 0,00 | 0 | 0 | 0 |
4. | ![]() | 1 | Eemeli STENROOS | 3 | 140 | 14 | 0 | 14 | 6,00 | 0,00 | 0 | 0 | 0 |
5. | ![]() | 30 | Jan BEDNÁŘ | 4 | 200 | 19 | 0 | 19 | 5,70 | 0,00 | 0 | 0 | 0 |
Zobrazuji nejlepších 5. Zobrazit vše.
Statistiky hráčů v poli
tým | # | Jméno a příjmení | Z | Min | G | A | V | B | TM | 2-5-o-k-th | ||
1. | ![]() | 77 | Mikhail ABRAMOV | U | 5 | - | 8 | 10 | - | 18 | 0 | 0 - 0 - 0 - 0 - 0 |
2. | ![]() | 17 | Ruslan ABROSIMOV | U | 5 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
3. | ![]() | 15 | Viktor ALEKSANDROV | O | 5 | - | 0 | 0 | - | 0 | 14 | 2 - 0 - 1 - 0 - 0 |
4. | ![]() | 2 | Malik ALISHLALOV | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
5. | ![]() | 5 | Gleb ANDREYEV | O | 5 | - | 2 | 1 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
6. | ![]() | 17 | Raivis Kristians ANSONS | U | 5 | - | 2 | 0 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
7. | ![]() | 24 | Egor ARBUZOV | O | 5 | - | 1 | 2 | - | 3 | 4 | 2 - 0 - 0 - 0 - 0 |
8. | ![]() | 24 | Nikita BELOČICKIS | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
9. | ![]() | 10 | Vítek BENDA | O | 5 | - | 0 | 1 | - | 1 | 2 | 1 - 0 - 0 - 0 - 0 |
10. | ![]() | 91 | Adam BERÁNEK | U | 5 | - | 3 | 2 | - | 5 | 8 | 4 - 0 - 0 - 0 - 0 |
11. | ![]() | 10 | Maxim BERYOZKIN | U | 5 | - | 3 | 3 | - | 6 | 2 | 1 - 0 - 0 - 0 - 0 |
12. | ![]() | 22 | Daniils BERZINŠ | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
13. | ![]() | 16 | Tomáš BÍLEK | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
14. | ![]() | 9 | Dominik BINIAS | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
15. | ![]() | 14 | Aleksandrs BIŠKINS | U | 5 | - | 5 | 2 | - | 7 | 31 | 3 - 1 - 0 - 1 - 0 |
16. | ![]() | 6 | Marek BLÁHA | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
17. | ![]() | 18 | Georgi BLOKHIN | O | 5 | - | 0 | 1 | - | 1 | 2 | 1 - 0 - 0 - 0 - 0 |
18. | ![]() | 4 | Dominik BOKŠTEFEL | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
19. | ![]() | 13 | Artūrs BOROVSKIS | O | 5 | - | 0 | 3 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
20. | ![]() | 14 | Tobiáš BRANC | U | 2 | - | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.