SELECT * FROM matches_types m, tables t, tables_teams tt
LEFT OUTER JOIN opponents o ON(tt.id_team = o.id_opponent)
WHERE tt.id_table = t.id_table AND t.id_season = '13' AND t.id_category = 17 AND t.id_type = m.id_type AND m.rewrite = 1
ORDER BY tt.points DESC, tt.score DESC, tt.scored DESC, o.shortname
Pořadí |
Tým |
Zápasy |
Výhry |
VvP | PvP | Prohry |
Skóre |
Rozdíl |
Body |
1. |
HC Příbram |
17 |
14 |
1 | 1 |
1 |
91:24 |
67 |
45 |
2. |
HC Býci Karviná |
17 |
8 |
2 | 1 |
6 |
60:48 |
12 |
29 |
3. |
HC 2001 Kladno |
16 |
7 |
0 | 2 |
7 |
43:59 |
-16 |
23 |
4. |
HC Litvínov |
18 |
1 |
1 | 0 |
16 |
39:112 |
-73 |
5 |