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='2017' 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 | |
| 1. | TRI | 2 | Patrik ŠVANČARA | 4 | 214 | 23 | 0 | 23 | 6,45 | 0,00 | 0 | 0 | 0 |
| 2. | VIT | 31 | Marek MICKA | 3 | 150 | 16 | 0 | 16 | 6,40 | 0,00 | 0 | 0 | 0 |
| 3. | ESP | 30 | Teemu RIIHIMÄKI | 3 | 160 | 16 | 0 | 16 | 6,00 | 0,00 | 0 | 0 | 0 |
| 4. | ESP | 1 | Eemeli STENROOS | 3 | 140 | 14 | 0 | 14 | 6,00 | 0,00 | 0 | 0 | 0 |
| 5. | KVA | 30 | Jan BEDNÁŘ | 4 | 200 | 19 | 0 | 19 | 5,70 | 0,00 | 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. | RIG | 14 | Aleksandrs BIŠKINS | U | 5 | - | 5 | 2 | - | 7 | 31 | 3 - 1 - 0 - 1 - 0 |
| 2. | ESP | 6 | Hugo RIKKILÄ | O | 5 | - | 1 | 2 | - | 3 | 27 | 1 - 1 - 0 - 1 - 0 |
| 3. | LOK | 28 | Daniil GUTIK | U | 5 | - | 6 | 0 | - | 6 | 20 | 5 - 0 - 1 - 0 - 0 |
| 4. | CSK | 70 | Matvei GUSKOV | U | 5 | - | 1 | 6 | - | 7 | 18 | 4 - 0 - 1 - 0 - 0 |
| 5. | SPA | 11 | Marcel ČÍŽEK | U | 5 | - | 8 | 5 | - | 13 | 16 | 3 - 0 - 1 - 0 - 0 |
| 6. | CSK | 15 | Viktor ALEKSANDROV | O | 5 | - | 0 | 0 | - | 0 | 14 | 2 - 0 - 1 - 0 - 0 |
| 7. | CSK | 29 | Grigiri MUKHANOV | U | 5 | - | 5 | 1 | - | 6 | 12 | 6 - 0 - 0 - 0 - 0 |
| 8. | ESP | 25 | Aleksi POIKSELKÄ | O | 5 | - | 1 | 0 | - | 1 | 10 | 5 - 0 - 0 - 0 - 0 |
| 9. | RIG | 7 | Emils MEŽNIEKS-ZAHARS | O | 5 | - | 0 | 0 | - | 0 | 10 | 5 - 0 - 0 - 0 - 0 |
| 10. | TRI | 46 | Adam RAŠKA | U | 5 | - | 2 | 6 | - | 8 | 8 | 4 - 0 - 0 - 0 - 0 |
| 11. | RIG | 9 | Rudolfs POLCS | U | 5 | - | 3 | 3 | - | 6 | 8 | 4 - 0 - 0 - 0 - 0 |
| 12. | VIT | 91 | Adam BERÁNEK | U | 5 | - | 3 | 2 | - | 5 | 8 | 4 - 0 - 0 - 0 - 0 |
| 13. | KVA | 8 | Tomáš ZDENĚK | U | 5 | - | 2 | 2 | - | 4 | 8 | 4 - 0 - 0 - 0 - 0 |
| 14. | VIT | 16 | Filip PLÁNKA | O | 5 | - | 0 | 0 | - | 0 | 8 | 4 - 0 - 0 - 0 - 0 |
| 15. | LOK | 19 | Ilya NIKOLAYEV | U | 5 | - | 2 | 4 | - | 6 | 6 | 3 - 0 - 0 - 0 - 0 |
| 16. | KVA | 6 | Vladislav POHANKA | O | 5 | - | 0 | 3 | - | 3 | 6 | 3 - 0 - 0 - 0 - 0 |
| 17. | ESP | 2 | Roni HIRVONEN | U | 5 | - | 2 | 0 | - | 2 | 6 | 3 - 0 - 0 - 0 - 0 |
| 18. | ESP | 9 | Edward RISSANEN | U | 5 | - | 1 | 1 | - | 2 | 6 | 3 - 0 - 0 - 0 - 0 |
| 19. | TRI | 9 | Matouš ČMIEL | U | 5 | - | 0 | 2 | - | 2 | 6 | 3 - 0 - 0 - 0 - 0 |
| 20. | VIT | 19 | Petr SMIČKA | U | 5 | - | 0 | 2 | - | 2 | 6 | 3 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.







