MENU
Statistiky brankářů (SPA)
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='2018' AND stats_suma.tym='SPA' 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. |  SPA | 2 | Josef SLUKA | 2 | 120 | 6 | 0 | 6 | 3,00 | 0,00 | 0 | 0 | 0 |
| 2. | SPA | 1 | Oldřich CICHOŇ | 3 | 180 | 8 | 0 | 8 | 2,67 | 0,00 | 0 | 0 | 0 |
Zobrazuji nejlepších 5. Zobrazit vše.
Statistiky hráčů v poli (SPA)
| tým | # | Jméno a příjmení | Z | Min | G | A | V | B | TM | 2-5-o-k-th | ||
| 1. | SPA | 19 | Michal VITOUCH | U | 5 | - | 3 | 1 | - | 4 | 0 | 0 - 0 - 0 - 0 - 0 |
| 2. | SPA | 20 | Andrej ADAMEC | U | 5 | - | 2 | 2 | - | 4 | 2 | 1 - 0 - 0 - 0 - 0 |
| 3. | SPA | 15 | Maxim KUBÁNEK | U | 5 | - | 2 | 2 | - | 4 | 12 | 6 - 0 - 0 - 0 - 0 |
| 4. | SPA | 4 | Marek BLÁHA | O | 5 | - | 1 | 2 | - | 3 | 4 | 2 - 0 - 0 - 0 - 0 |
| 5. | SPA | 37 | Tomáš HAMARA | O | 5 | - | 1 | 1 | - | 2 | 0 | 0 - 0 - 0 - 0 - 0 |
| 6. | SPA | 8 | Filip DUCHÁČ | O | 5 | - | 1 | 1 | - | 2 | 2 | 1 - 0 - 0 - 0 - 0 |
| 7. | SPA | 13 | Josef SLAVÍČEK | U | 5 | - | 1 | 1 | - | 2 | 6 | 3 - 0 - 0 - 0 - 0 |
| 8. | SPA | 22 | Adam MÁCHA | U | 5 | - | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 9. | SPA | 17 | Michal VÁGNER | U | 5 | - | 1 | 0 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 10. | SPA | 7 | Šimon TRUHLÁŘ | O | 5 | - | 0 | 1 | - | 1 | 0 | 0 - 0 - 0 - 0 - 0 |
| 11. | SPA | 6 | Nikita GURYEVSKIY | O | 5 | - | 0 | 1 | - | 1 | 4 | 2 - 0 - 0 - 0 - 0 |
| 12. | SPA | 23 | Josef BROŠ | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 13. | SPA | 25 | Jakub UHLÍŘ | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 14. | SPA | 26 | Denis VALENTA | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 15. | SPA | 24 | Oto THEIMER | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 16. | SPA | 18 | Radek VÍTŮ | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 17. | SPA | 27 | Kryštof CAPOUŠEK | U | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 18. | SPA | 12 | Ondřej MAŠEK | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 19. | SPA | 10 | Jakub PROCHÁZKA | O | 5 | - | 0 | 0 | - | 0 | 0 | 0 - 0 - 0 - 0 - 0 |
| 20. | SPA | 16 | Matěj JAROŠ | U | 5 | - | 0 | 0 | - | 0 | 2 | 1 - 0 - 0 - 0 - 0 |
Zobrazuji prvních 20. Zobrazit vše.