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='2023DOR' AND stats_suma.tym='HSR' AND hrac.post='B' ORDER BY stats_suma.uspesnost DESC, 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 |
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 | 44 | Rojs ĀLUPS | O | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 2. | HSR | 27 | Sandis AUZIŅŠ | U | 2 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 3. | HSR | 26 | MĀRTIŅŠ BIEZAIS | U | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 4. | HSR | 38 | Oskars BRIEDIS | O | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 5. | HSR | 54 | Edvards BUČIŅŠ | U | 2 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 6. | HSR | 14 | Dmitrijs DIĻEVKA | U | 2 | - | 2 | 0 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
| 7. | HSR | 25 | Vladislavs DUBROVSKIS | U | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 8. | HSR | 59 | IĻJA GAVRILOVS | U | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 9. | HSR | 50 | Vladislavs IĻJUŠINS | O | 2 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
| 10. | HSR | 35 | Rauls KAPURA | U | 2 | - | 2 | 0 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 11. | HSR | 7 | Rauls LADUSĀNS | O | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 12. | HSR | 24 | DAŅILA LOBAČEVS | U | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 13. | HSR | 11 | Antons MACIJEVSKIS | U | 2 | - | 4 | 0 | - | 4 | 0 | 0 - 0 - 0 - 0 - 0 |
| 14. | HSR | 33 | Ričards PĒTERSONS | O | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 15. | HSR | 10 | Roberts POLIS | U | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 16. | HSR | 21 | Krists RETENAIS | O | 2 | - | 0 | 2 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
| 17. | HSR | 45 | MĀRCIS SMIRNOVS | U | 2 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 18. | HSR | 46 | Anatolijs TOVARIŠS | O | 2 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 19. | HSR | 47 | Aleksandrs ZAPRIVODA | U | 2 | - | 1 | 2 | - | 3 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | HSR | 51 | Helmuts ZARIŅŠ | O | 2 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.









