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='2023DOR' AND hrac.post='B' ORDER BY stats_suma.strely 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 |
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. | UKR | 11 | Gavryil SIMCHUK | U | 2 | - | 2 | 2 | - | 4 | 2 | 1 - 0 - 0 - 0 - 0 |
| 2. | HSR | 47 | Aleksandrs ZAPRIVODA | U | 2 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 3. | SPA | 10 | Filip TOPOL | U | 2 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 4. | SPA | 18 | Petr POLÁČEK | U | 2 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 5. | SPA | 12 | Daniel NOVOTNÝ | U | 2 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 6. | SPA | 21 | David HRUBÝ | U | 2 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 7. | TRI | 21 | Šimon POHLUDKA | U | 2 | - | 1 | 2 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
| 8. | UKR | 15 | Rodion KOIDA | U | 2 | - | 1 | 2 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
| 9. | SAL | 17 | Rio KAISER | O | 2 | - | 1 | 2 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
| 10. | TRI | 51 | Danny BARNA | U | 2 | - | 0 | 2 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 11. | SAL | 10 | Raphael RIEPL | U | 2 | - | 0 | 2 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 12. | SAL | 20 | Adrian GESSON | U | 2 | - | 0 | 2 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 13. | HSR | 21 | Krists RETENAIS | O | 2 | - | 0 | 2 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
| 14. | TRI | 54 | Robin ŠVANČARA | U | 2 | - | 3 | 1 | - | 4 | 4 | 2 - 0 - 0 - 0 - 0 |
| 15. | UKR | 17 | Danyil SHULHA | U | 2 | - | 2 | 1 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 16. | VIT | 90 | Jiří LERCH | U | 2 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 17. | VIT | 28 | Matyáš HANÁK | U | 2 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 18. | SPA | 15 | Daniel JAKAB | U | 2 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 19. | UKR | 16 | Andrii VYSTAVKIN | U | 2 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | SPA | 24 | Adam DUFEK | O | 2 | - | 1 | 1 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.









