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.zasahy 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. | KVA | 7 | Matěj KUBÁT | 1 | 25 | 6 | 0 | 6 | 14,40 | 0,00 | 0 | 0 | 0 |
| 2. | TRN | 34 | Adam GERHARDT | 2 | 92 | 14 | 0 | 14 | 9,13 | 0,00 | 0 | 0 | 0 |
| 3. | TRI | 3 | Marek MACURA | 1 | 60 | 8 | 0 | 8 | 8,00 | 0,00 | 0 | 0 | 0 |
| 4. | HSR | 1 | Patriks BERZINS | 2 | 120 | 13 | 0 | 13 | 6,50 | 0,00 | 0 | 0 | 0 |
| 5. | SBA | 1 | Sebastián RUSNÁK | 3 | 180 | 17 | 0 | 17 | 5,67 | 0,00 | 0 | 0 | 2 |
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. | VIT | 31 | René SMOLKA | O | 5 | - | 1 | 4 | - | 5 | 31 | 3 - 1 - 0 - 1 - 0 |
| 2. | CSK | 2 | Artem GRUSHNIKOV | O | 5 | - | 2 | 6 | - | 8 | 27 | 1 - 1 - 0 - 1 - 0 |
| 3. | SBA | 76 | Filip MOLNÁR | U | 5 | - | 0 | 0 | - | 0 | 14 | 2 - 0 - 1 - 0 - 0 |
| 4. | KVA | 27 | David PROŠEK | O | 5 | - | 0 | 0 | - | 0 | 14 | 7 - 0 - 0 - 0 - 0 |
| 5. | VIT | 15 | Josef KREJSA | U | 5 | - | 5 | 2 | - | 7 | 8 | 4 - 0 - 0 - 0 - 0 |
| 6. | HSR | 15 | Marks KANINS | U | 5 | - | 4 | 0 | - | 4 | 8 | 4 - 0 - 0 - 0 - 0 |
| 7. | KVA | 18 | Jakub VOGEL | O | 5 | - | 0 | 3 | - | 3 | 8 | 4 - 0 - 0 - 0 - 0 |
| 8. | HSR | 7 | Daniles GONTARS | O | 5 | - | 0 | 2 | - | 2 | 8 | 4 - 0 - 0 - 0 - 0 |
| 9. | SPA | 25 | Patrik BRŮNA | O | 5 | - | 0 | 2 | - | 2 | 8 | 4 - 0 - 0 - 0 - 0 |
| 10. | KVA | 26 | Miroslav CZINGEL | U | 5 | - | 0 | 0 | - | 0 | 8 | 4 - 0 - 0 - 0 - 0 |
| 11. | VIT | 88 | Marek BRADA | U | 5 | - | 2 | 3 | - | 5 | 6 | 3 - 0 - 0 - 0 - 0 |
| 12. | TRI | 24 | Daniel CHOVANIAK | O | 5 | - | 1 | 0 | - | 1 | 6 | 3 - 0 - 0 - 0 - 0 |
| 13. | TRN | 81 | Michal HRUŠKA | O | 5 | - | 1 | 0 | - | 1 | 6 | 3 - 0 - 0 - 0 - 0 |
| 14. | TRN | 11 | Šimon MIKLOVIČ | O | 5 | - | 1 | 0 | - | 1 | 6 | 3 - 0 - 0 - 0 - 0 |
| 15. | TRI | 25 | Patrik BUJÁK | O | 5 | - | 0 | 0 | - | 0 | 6 | 3 - 0 - 0 - 0 - 0 |
| 16. | HSR | 19 | Martins SULCS | U | 5 | - | 3 | 3 | - | 6 | 4 | 2 - 0 - 0 - 0 - 0 |
| 17. | VIT | 18 | Ondřej CUBO | O | 5 | - | 2 | 4 | - | 6 | 4 | 2 - 0 - 0 - 0 - 0 |
| 18. | HSR | 21 | Martins SPAKS | U | 5 | - | 4 | 1 | - | 5 | 4 | 2 - 0 - 0 - 0 - 0 |
| 19. | SBA | 9 | Alex GÉCI | U | 5 | - | 3 | 1 | - | 4 | 4 | 2 - 0 - 0 - 0 - 0 |
| 20. | VIT | 19 | Tomáš MACHŮ | O | 5 | - | 2 | 2 | - | 4 | 4 | 2 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.







