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='2019' AND hrac.post='B' ORDER BY stats_suma.nuly DESC, stats_suma.prumer DESC, stats_suma.prumer ASC, stats_suma.minuty DESC, stats_suma.strely DESC LIMIT 5| tým | # | Jméno a příjmení | Z | Min | Stř | Zás | Ink | Prů | Úsp | SO | A | TM | |
| 1. | CSK | 31 | Arsenii IAKOVLEV | 2 | 120 | 0 | 0 | 0 | 0,00 | 0,00 | 2 | 0 | 0 |
| 2. | KVA | 1 | Matyáš BAJGAR | 5 | 275 | 19 | 0 | 19 | 4,15 | 0,00 | 1 | 0 | 0 |
| 3. | VIT | 37 | Marian MUNCH | 3 | 180 | 11 | 0 | 11 | 3,67 | 0,00 | 1 | 0 | 0 |
| 4. | SBA | 2 | Dominik BOVAN | 2 | 120 | 6 | 0 | 6 | 3,00 | 0,00 | 1 | 0 | 0 |
| 5. | SPA | 1 | Josef SLUKA | 3 | 180 | 8 | 0 | 8 | 2,67 | 0,00 | 1 | 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. | CSK | 2 | Artem GRUSHNIKOV | O | 5 | - | 2 | 6 | - | 8 | 27 | 1 - 1 - 0 - 1 - 0 |
| 2. | HSR | 2 | Patriks SEILIS | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 3. | HSR | 3 | Reinis EBERLINS | O | 5 | - | 0 | 0 | - | 0 | 4 | 2 - 0 - 0 - 0 - 0 |
| 4. | SPA | 4 | Nino TOMOV | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 5. | HSR | 4 | Dmitrijs KOROLS | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 6. | KVA | 4 | Petr ZOLNAJ | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 7. | TRI | 4 | Maroš KRIŠČÁK | U | 5 | - | 0 | 0 | - | 0 | 4 | 2 - 0 - 0 - 0 - 0 |
| 8. | KVA | 5 | Alexandr REMEŠ | U | 5 | - | 5 | 4 | - | 9 | 2 | 1 - 0 - 0 - 0 - 0 |
| 9. | SBA | 5 | Robin VEBER | U | 5 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 10. | CSK | 5 | Artur CHOLACH | O | 5 | - | 0 | 1 | - | 1 | 2 | 1 - 0 - 0 - 0 - 0 |
| 11. | TRI | 5 | Sebastian CIENCIALA | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 12. | SPA | 5 | Ondřej MAŠEK | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 13. | HSR | 5 | Ralfs KARKLINS | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 14. | CSK | 6 | Stiven SARDARIAN | U | 5 | - | 7 | 15 | - | 22 | 0 | 0 - 0 - 0 - 0 - 0 |
| 15. | VIT | 6 | Michal BYSTROŇ | O | 5 | - | 0 | 2 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 16. | TRI | 6 | Filip HRŮZEK | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 17. | SBA | 6 | Martin MORONG | O | 5 | - | 0 | 0 | - | 0 | 4 | 2 - 0 - 0 - 0 - 0 |
| 18. | HSR | 6 | Vladimirs ZAICEVS | O | 5 | - | 0 | 0 | - | 0 | 4 | 2 - 0 - 0 - 0 - 0 |
| 19. | CSK | 7 | Vasilii DRONYK | U | 5 | - | 2 | 1 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | HSR | 7 | Daniles GONTARS | O | 5 | - | 0 | 2 | - | 2 | 8 | 4 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.







