MENU
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.minuty 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 | 1 | Jan ŠKORPÍK | 4 | 240 | 12 | 0 | 12 | 3,00 | 0,00 | 0 | 0 | 0 |
| 2. |  TRI | 2 | Patrik ŠVANČARA | 4 | 214 | 23 | 0 | 23 | 6,45 | 0,00 | 0 | 0 | 0 |
| 3. |  KVA | 30 | Jan BEDNÁŘ | 4 | 200 | 19 | 0 | 19 | 5,70 | 0,00 | 0 | 0 | 0 |
| 4. |  LOK | 35 | Yegor TULEPOV | 3 | 180 | 12 | 0 | 12 | 4,00 | 0,00 | 0 | 0 | 0 |
| 5. |  CSK | 30 | Vsevolod SKOTNIKOV | 3 | 180 | 6 | 0 | 6 | 2,00 | 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. | CSK | 77 | Mikhail ABRAMOV | U | 5 | - | 8 | 10 | - | 18 | 0 | 0 - 0 - 0 - 0 - 0 |
| 2. | CSK | 23 | Danila KHULAPOV | U | 5 | - | 5 | 5 | - | 10 | 0 | 0 - 0 - 0 - 0 - 0 |
| 3. | CSK | 8 | Alexander CHERNOV | U | 5 | - | 7 | 1 | - | 8 | 2 | 1 - 0 - 0 - 0 - 0 |
| 4. | CSK | 26 | Daniel BUTSAYEV | U | 5 | - | 4 | 4 | - | 8 | 2 | 1 - 0 - 0 - 0 - 0 |
| 5. | CSK | 11 | Alexandr CHERNY | U | 5 | - | 2 | 5 | - | 7 | 2 | 1 - 0 - 0 - 0 - 0 |
| 6. | CSK | 70 | Matvei GUSKOV | U | 5 | - | 1 | 6 | - | 7 | 18 | 4 - 0 - 1 - 0 - 0 |
| 7. | CSK | 29 | Grigiri MUKHANOV | U | 5 | - | 5 | 1 | - | 6 | 12 | 6 - 0 - 0 - 0 - 0 |
| 8. | CSK | 22 | Nikita OLEINIK | O | 5 | - | 3 | 1 | - | 4 | 2 | 1 - 0 - 0 - 0 - 0 |
| 9. | CSK | 18 | Alexander SHAPOSNIKOV | O | 5 | - | 1 | 3 | - | 4 | 0 | 0 - 0 - 0 - 0 - 0 |
| 10. | CSK | 44 | Dmitri GUNDYREV | U | 5 | - | 0 | 4 | - | 4 | 2 | 1 - 0 - 0 - 0 - 0 |
| 11. | CSK | 5 | Gleb ANDREYEV | O | 5 | - | 2 | 1 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 12. | CSK | 51 | Danila RUSSU | U | 5 | - | 1 | 2 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
| 13. | CSK | 24 | Egor ARBUZOV | O | 5 | - | 1 | 2 | - | 3 | 4 | 2 - 0 - 0 - 0 - 0 |
| 14. | CSK | 16 | Daniil SHEBYAKIN | U | 5 | - | 2 | 0 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 15. | CSK | 42 | Ivan YUDIN | O | 5 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 16. | CSK | 7 | Maxim SHINDYAIKIN | O | 5 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 17. | CSK | 4 | Egor STEPANOV | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 18. | CSK | 2 | Malik ALISHLALOV | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 19. | CSK | 57 | Alexander NIKISHIN | O | 5 | - | 0 | 0 | - | 0 | 4 | 2 - 0 - 0 - 0 - 0 |
| 20. | CSK | 15 | Viktor ALEKSANDROV | O | 5 | - | 0 | 0 | - | 0 | 14 | 2 - 0 - 1 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.