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='2022DOR' AND hrac.post='B' ORDER BY stats_suma.tm 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. | MLM | 35 | Lowe PIHLBLAD | 1 | 60 | 50 | 37 | 13 | 13,00 | 74,00 | 0 | 0 | 0 |
| 2. | VIT | 37 | Štěpán VÁVRA | 1 | 60 | 42 | 33 | 9 | 9,00 | 78,57 | 0 | 0 | 0 |
| 3. | MLM | 30 | Wiggo CARLGREN | 3 | 154 | 104 | 67 | 11 | 4,29 | 64,42 | 0 | 0 | 0 |
| 4. | KVA | 2 | Adam DYBAL | 3 | 179 | 86 | 74 | 12 | 4,02 | 86,05 | 0 | 0 | 0 |
| 5. | POP | 31 | Miroslav PISARČÍK | 3 | 165 | 68 | 57 | 11 | 4,00 | 83,82 | 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. | MLM | 2 | Ted WELANDER | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 2. | VIT | 3 | Kamil DRÁBEK | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 3. | VIT | 4 | Sebastian GLAS | U | 5 | - | 1 | 5 | - | 6 | 0 | 0 - 0 - 0 - 0 - 0 |
| 4. | KVA | 5 | Matyáš ADÁMEK | U | 5 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 5. | TRI | 5 | Robin GERYCH | U | 5 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 6. | TRI | 6 | Miroslav HOLINKA | U | 5 | - | 6 | 1 | - | 7 | 2 | 1 - 0 - 0 - 0 - 0 |
| 7. | KVA | 6 | Matteo KOČÍ | O | 5 | - | 2 | 0 | - | 2 | 10 | 5 - 0 - 0 - 0 - 0 |
| 8. | VIT | 6 | Alex FALHAR | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 9. | MLM | 6 | Svante BOGNÄS | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 10. | SPA | 7 | Šimon POTOMA | U | 5 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 11. | TRN | 7 | Jakub CHROMIAK | O | 5 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 12. | POP | 7 | Patrik VAVERČÁK | O | 5 | - | 0 | 3 | - | 3 | 6 | 3 - 0 - 0 - 0 - 0 |
| 13. | VIT | 7 | Ondřej KRČMARSKÝ | U | 5 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 14. | TRI | 8 | Patrik VOLAS | U | 2 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 15. | TRI | 8 | Patrik VOLAS | U | 3 | - | 0 | 3 | - | 3 | 6 | 3 - 0 - 0 - 0 - 0 |
| 16. | SPA | 8 | Martin VAŠÍČEK | U | 5 | - | 7 | 4 | - | 11 | 0 | 0 - 0 - 0 - 0 - 0 |
| 17. | MLM | 8 | Viggo SÖDERBERG | U | 5 | - | 1 | 1 | - | 2 | 4 | 2 - 0 - 0 - 0 - 0 |
| 18. | POP | 8 | Michael ŠELIGA | O | 5 | - | 1 | 0 | - | 1 | 2 | 1 - 0 - 0 - 0 - 0 |
| 19. | TRN | 8 | Dávid PORUBSKÝ | U | 5 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | SPA | 9 | Mikuláš ODEHNAL | U | 5 | - | 2 | 4 | - | 6 | 2 | 1 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.







