Statistiky brankářů (MIN)
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='2018' AND stats_suma.tym='MIN' 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 5| tým | # | Jméno a příjmení | Z | Min | Stř | Zás | Ink | Prů | Úsp | SO | A | TM | |
| 1. | MIN | 31 | Alexei KOLOSOV | 4 | 240 | 10 | 0 | 10 | 2,50 | 0,00 | 1 | 0 | 0 |
| 2. | MIN | 20 | Valiantsin LIAONAU | 1 | 60 | 3 | 0 | 3 | 3,00 | 0,00 | 0 | 0 | 0 |
Zobrazuji nejlepších 5. Zobrazit vše.
Statistiky hráčů v poli (MIN)
| tým | # | Jméno a příjmení | Z | Min | G | A | V | B | TM | 2-5-o-k-th | ||
| 1. | MIN | 22 | Maxim SAZANOVETS | U | 5 | - | 2 | 1 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
| 2. | MIN | 19 | Alexei CHERNIKOV | U | 5 | - | 2 | 1 | - | 3 | 4 | 2 - 0 - 0 - 0 - 0 |
| 3. | MIN | 95 | Ilya ZHUR | U | 5 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 4. | MIN | 5 | Egor SHKLYAREVSKY | U | 5 | - | 1 | 2 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
| 5. | MIN | 11 | Pavel OSOVSKI | U | 5 | - | 2 | 0 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 6. | MIN | 77 | Maxim SLABKO | O | 5 | - | 1 | 1 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
| 7. | MIN | 23 | Artur SHAVLYUK | U | 5 | - | 0 | 2 | - | 2 | 4 | 2 - 0 - 0 - 0 - 0 |
| 8. | MIN | 15 | Arthur SHUNDRIK | O | 5 | - | 0 | 2 | - | 2 | 4 | 2 - 0 - 0 - 0 - 0 |
| 9. | MIN | 13 | Gennady KOLESOV | U | 5 | - | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 10. | MIN | 39 | Ilya TSUGIN | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 11. | MIN | 91 | Vlas PISAREV | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 12. | MIN | 27 | Ivan KOROVAYKIN | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 13. | MIN | 64 | Vladimir ZUBOVICH | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 14. | MIN | 55 | Nikita DABIZHA | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 15. | MIN | 28 | Clement ZHMURKIN | U | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 16. | MIN | 87 | Ilya KALENKOVICH | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 17. | MIN | 2 | Mikhail KALACH | O | 5 | - | 0 | 0 | - | 0 | 6 | 3 - 0 - 0 - 0 - 0 |
| 18. | MIN | 71 | Egor DALKARD | O | 5 | - | 0 | 0 | - | 0 | 8 | 4 - 0 - 0 - 0 - 0 |
| 19. | MIN | 9 | Daniil LIS | U | 5 | - | 0 | 0 | - | 0 | 10 | 5 - 0 - 0 - 0 - 0 |
| 20. | MIN | 33 | Evgeny POUTINE | O | 5 | - | 0 | 0 | - | 0 | 10 | 5 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.







