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.prumer 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 | 1 | Petr PŘIKRYL | 3 | 120 | 78 | 69 | 9 | 0,00 | 0,00 | 0 | 0 | 0 |
| 2. | SPA | 2 | Max KOGLER | 3 | 120 | 44 | 37 | 6 | 0,00 | 0,00 | 1 | 0 | 0 |
| 3. | TRI | 3 | Jakub MILOTA | 3 | 60 | 30 | 27 | 0 | 0,00 | 0,00 | 1 | 0 | 0 |
| 4. | HSR | 32 | Emīls ŠVEIDE | 1 | 60 | 18 | 17 | 0 | 0,00 | 94,44 | 1 | 0 | 0 |
| 5. | TRN | 30 | Adam KUKUČKA | 1 | 25 | 15 | 14 | 0 | 0,00 | 93,33 | 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. | HSR | 29 | Aleks ĻEONOVS | O | 5 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 2. | KVA | 5 | Matyáš ADÁMEK | U | 5 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 3. | MLM | 19 | Victor ANDERSSON | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 4. | MLM | 25 | Viktor ANDERSSON | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 5. | HSR | 55 | Kristers ANSONS | U | 5 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 6. | KVA | 24 | Jakub ANTON | O | 5 | - | 1 | 0 | - | 1 | 2 | 1 - 0 - 0 - 0 - 0 |
| 7. | MLM | 20 | Sean BANEGAS | U | 5 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 8. | SPA | 19 | Tomáš BARTOŇ | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 9. | VIT | 24 | Šimon BIALY | O | 5 | - | 2 | 1 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 10. | SPA | 20 | Arkadij BJAKOV | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 11. | TRI | 23 | David BLAHA | U | 5 | - | 2 | 1 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
| 12. | MLM | 6 | Svante BOGNÄS | O | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 13. | HSR | 27 | Rodions BOLTRAMOVIČS | U | 5 | - | 1 | 2 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
| 14. | POP | 25 | Dávid BOŽOŇ | U | 5 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 15. | POP | 27 | Marek BREJČÁK | O | 5 | - | 0 | 1 | - | 1 | 4 | 2 - 0 - 0 - 0 - 0 |
| 16. | POP | 70 | Viktor BREZINA | O | 5 | - | 1 | 0 | - | 1 | 2 | 1 - 0 - 0 - 0 - 0 |
| 17. | HSR | 38 | Oskars BRIEDIS | O | 5 | - | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 18. | TRI | 37 | Dominik BUJÁK | O | 5 | - | 2 | 2 | - | 4 | 8 | 4 - 0 - 0 - 0 - 0 |
| 19. | HSR | 47 | Pēteris BULāNS | O | 5 | - | 3 | 1 | - | 4 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | MLM | 21 | Felix CARELL | O | 5 | - | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.







