Statistiky brankářů (HSR)
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 stats_suma.tym='HSR' AND hrac.post='B' ORDER BY stats_suma.nuly 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. | HSR | 30 | Ivans KUFTERINS | 1 | 59 | 29 | 26 | 3 | 3,05 | 89,66 | 0 | 0 | 0 |
| 2. | HSR | 41 | Roberts KRAVALIS | 2 | 120 | 72 | 68 | 4 | 2,00 | 94,44 | 0 | 0 | 0 |
| 3. | HSR | 30 | Ivans KUFTERINS | 2 | 120 | 67 | 64 | 3 | 1,50 | 95,52 | 0 | 0 | 0 |
Zobrazuji nejlepších 5. Zobrazit vše.
Statistiky hráčů v poli (HSR)
| tým | # | Jméno a příjmení | Z | Min | G | A | V | B | TM | 2-5-o-k-th | ||
| 1. | HSR | 25 | Roberts Janis POLIS | U | 4 | 35 Min 2Sek | 3 | 3 | 25,00 | 6 | 0 | 0 - 0 - 0 - 0 - 0 |
| 2. | HSR | 34 | Leonards Janis SPRIESLIS | U | 4 | 28 Min 27Sek | 3 | 2 | - | 5 | 2 | 1 - 0 - 0 - 0 - 0 |
| 3. | HSR | 13 | Jaroslavs CIRKINS | U | 4 | 35 Min 12Sek | 2 | 3 | 31,00 | 5 | 6 | 3 - 0 - 0 - 0 - 0 |
| 4. | HSR | 16 | Kristers OBUKS | U | 4 | 32 Min 34Sek | 1 | 4 | 23,00 | 5 | 2 | 1 - 0 - 0 - 0 - 0 |
| 5. | HSR | 56 | Kristians UTNANS | U | 4 | 37 Min 43Sek | 1 | 4 | - | 5 | 6 | 3 - 0 - 0 - 0 - 0 |
| 6. | HSR | 29 | Toms KUZMINS | U | 4 | 34 Min 52Sek | 3 | 1 | 23,00 | 4 | 4 | 2 - 0 - 0 - 0 - 0 |
| 7. | HSR | 58 | Rolands RAMUTIS | U | 4 | 23 Min 55Sek | 2 | 1 | 29,00 | 3 | 4 | 2 - 0 - 0 - 0 - 0 |
| 8. | HSR | 8 | Markuss Gabriels GRINBERGS | O | 4 | 21 Min 39Sek | 1 | 1 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
| 9. | HSR | 18 | Krisjanis SARTS | O | 4 | 35 Min 42Sek | 0 | 2 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 10. | HSR | 51 | Leopols ARENBERGS | O | 4 | 37 Min 39Sek | 0 | 2 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
| 11. | HSR | 49 | Gustavs SPIGULIS | U | 4 | 24 Min 27Sek | 0 | 2 | 25,00 | 2 | 6 | 3 - 0 - 0 - 0 - 0 |
| 12. | HSR | 25 | Roberts Janis POLIS | U | 1 | 17 Min 29Sek | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 13. | HSR | 2 | Aleksandrs JELISEJEVS | U | 1 | 13 Min 53Sek | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 14. | HSR | 61 | Kristofers JAKS | O | 4 | 23 Min 39Sek | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 15. | HSR | 48 | Rodrigo BERKIS | U | 4 | 20 Min 58Sek | 1 | 0 | 50,00 | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 16. | HSR | 29 | Toms KUZMINS | U | 1 | 20 Min 16Sek | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 17. | HSR | 8 | Markuss Gabriels GRINBERGS | O | 1 | 16 Min 30Sek | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 18. | HSR | 22 | Stefans ROTS | U | 1 | 9 Min 45Sek | 0 | 1 | - | 1 | 2 | 1 - 0 - 0 - 0 - 0 |
| 19. | HSR | 57 | Rihards MEIKSANS | O | 4 | 36 Min 21Sek | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | HSR | 4 | Janis Gustavs GLAZNIEKS | O | 4 | 37 Min 48Sek | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.









