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='2016' AND hrac.post='B' ORDER BY stats_suma.inkas ASC, stats_suma.priorita 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. | SPA | 0 | Cassius JONES | 1 | 20 | 1 | 0 | 1 | 3,00 | 0,00 | 0 | 0 | 0 |
| 2. | CSK | 0 | Nikita BESPALOV | 1 | 60 | 1 | 0 | 1 | 1,00 | 0,00 | 0 | 0 | 0 |
| 3. | CSK | 0 | Denis RYBALKIN | 4 | 180 | 1 | 0 | 1 | 0,00 | 0,00 | 2 | 0 | 0 |
| 4. | VIT | 0 | Nick MALÍK | 2 | 120 | 4 | 0 | 4 | 2,00 | 0,00 | 0 | 0 | 0 |
| 5. | ESP | 0 | Topias UKKONEN | 2 | 90 | 5 | 0 | 5 | 3,33 | 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. | TRI | 0 | Michal KVASNICA | U | 5 | - | 9 | 3 | - | 12 | 4 | 2 - 0 - 0 - 0 - 0 |
| 2. | CSK | 0 | Lev KOMISSAROV | U | 5 | - | 8 | 3 | - | 11 | 6 | 3 - 0 - 0 - 0 - 0 |
| 3. | CSK | 0 | Nikita DOLGOPYATOV | U | 5 | - | 4 | 7 | - | 11 | 6 | 3 - 0 - 0 - 0 - 0 |
| 4. | CSK | 0 | Nikita RTISCHEV | U | 5 | - | 4 | 5 | - | 9 | 0 | 0 - 0 - 0 - 0 - 0 |
| 5. | KVA | 0 | Dominik ŠEDIVÝ | U | 5 | - | 8 | 0 | - | 8 | 4 | 2 - 0 - 0 - 0 - 0 |
| 6. | MIN | 0 | Arseni KALBASIN | U | 5 | - | 6 | 2 | - | 8 | 8 | 4 - 0 - 0 - 0 - 0 |
| 7. | CSK | 0 | Vladislav KOTKOV | U | 5 | - | 6 | 1 | - | 7 | 0 | 0 - 0 - 0 - 0 - 0 |
| 8. | SPA | 0 | Marcel ČÍŽEK | U | 5 | - | 4 | 3 | - | 7 | 0 | 0 - 0 - 0 - 0 - 0 |
| 9. | RIG | 0 | Patriks MARCINKEVIČS | U | 5 | - | 4 | 2 | - | 6 | 0 | 0 - 0 - 0 - 0 - 0 |
| 10. | VIT | 0 | Jakub KYLNAR | U | 5 | - | 4 | 2 | - | 6 | 0 | 0 - 0 - 0 - 0 - 0 |
| 11. | CSK | 0 | Artyom KOMAROV | O | 5 | - | 3 | 3 | - | 6 | 0 | 0 - 0 - 0 - 0 - 0 |
| 12. | CSK | 0 | Pavel KORESHKOV | U | 5 | - | 2 | 4 | - | 6 | 4 | 2 - 0 - 0 - 0 - 0 |
| 13. | TRI | 0 | Jonáš PETEREK | U | 5 | - | 2 | 4 | - | 6 | 4 | 2 - 0 - 0 - 0 - 0 |
| 14. | MIN | 0 | Roman YEREMEICHYK | U | 5 | - | 1 | 5 | - | 6 | 4 | 2 - 0 - 0 - 0 - 0 |
| 15. | TRI | 0 | Jakub MICHÁLEK | O | 5 | - | 4 | 1 | - | 5 | 10 | 5 - 0 - 0 - 0 - 0 |
| 16. | MIN | 0 | Nikita PYSHKAYLO | U | 5 | - | 3 | 2 | - | 5 | 0 | 0 - 0 - 0 - 0 - 0 |
| 17. | ESP | 0 | Pyry PUOLAKKA | U | 5 | - | 3 | 2 | - | 5 | 2 | 1 - 0 - 0 - 0 - 0 |
| 18. | CSK | 0 | Yuri SHKLYARUK | U | 5 | - | 3 | 2 | - | 5 | 4 | 2 - 0 - 0 - 0 - 0 |
| 19. | KVA | 0 | František KLEJNA | O | 5 | - | 2 | 3 | - | 5 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | TRI | 0 | Adam RAŠKA | U | 5 | - | 2 | 3 | - | 5 | 2 | 1 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.







