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 LIKE ('2024%') 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 | |
| 1. | SAL | 31 | Aaron KAISER | 3 | 180 | 100 | 89 | 11 | 3,67 | 89,00 | 1 | 0 | 0 |
| 2. | DAV | 30 | Jan Araujo VERAS RUCH | 2 | 120 | 83 | 73 | 10 | 5,00 | 87,95 | 0 | 0 | 0 |
| 3. | VIT | 37 | Sebastian VARGA | 2 | 120 | 79 | 64 | 15 | 7,50 | 81,01 | 0 | 0 | 2 |
| 4. | HSR | 41 | Roberts KRAVALIS | 2 | 120 | 72 | 68 | 4 | 2,00 | 94,44 | 0 | 0 | 0 |
| 5. | SBA | 1 | Filip HORNÁČEK | 2 | 120 | 68 | 58 | 10 | 5,00 | 85,29 | 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. | DAV | 21 | Nino SCHOCH | U | 1 | 23 Min 33Sek | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 2. | DAV | 7 | Gian SCHNEUWLY | O | 1 | 19 Min 55Sek | 1 | 0 | - | 1 | 2 | 1 - 0 - 0 - 0 - 0 |
| 3. | DAV | 3 | Martins BARTULIS | U | 1 | 17 Min 23Sek | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 4. | DAV | 8 | Joshua BRANDER | O | 1 | 20 Min 34Sek | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 5. | DAV | 18 | Stepan STEJSKAL | U | 1 | 17 Min 41Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 6. | DAV | 28 | Nael HUNZIKER | U | 1 | 22 Min 59Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 7. | DAV | 24 | Adam VOLEK | U | 1 | 15 Min 51Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 8. | DAV | 11 | Leevi SIMONET | U | 1 | 20 Min 40Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 9. | DAV | 10 | Jan AEBLI | U | 1 | 21 Min 42Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 10. | DAV | 12 | Loic WIESER | O | 1 | 16 Min 53Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 11. | DAV | 19 | Dylan BOCK | U | 1 | 19 Min 47Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 12. | DAV | 6 | Adrian EGGENBERGER | O | 1 | 15 Min 57Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 13. | DAV | 9 | Livio SCHENA | U | 1 | 18 Min 18Sek | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 14. | DAV | 5 | Henrik Laurin AEBLI | O | 1 | 20 Min 12Sek | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 15. | DAV | 27 | Rafael MARON | O | 1 | 23 Min 11Sek | 0 | 0 | - | 0 | 4 | 2 - 0 - 0 - 0 - 0 |
| 16. | DAV | 29 | Jan-Mica WÖCKE | U | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 17. | DAV | 23 | Noah GRÜNENFELDER | O | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 18. | DAV | 21 | Nino SCHOCH | U | 3 | 17 Min 12Sek | 3 | 1 | - | 4 | 0 | 0 - 0 - 0 - 0 - 0 |
| 19. | DAV | 28 | Nael HUNZIKER | U | 3 | 16 Min 27Sek | 3 | 1 | 6,00 | 4 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | DAV | 11 | Leevi SIMONET | U | 3 | 21 Min 46Sek | 0 | 3 | - | 3 | 2 | 1 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.









