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 |
18 |
15 |
1 | 1 |
1 |
95:25 |
70 |
48 |
| 2. |
HC Býci Karviná |
18 |
9 |
2 | 1 |
6 |
64:50 |
14 |
32 |
| 3. |
HC 2001 Kladno |
18 |
7 |
0 | 2 |
9 |
56:67 |
-11 |
23 |
| 4. |
HC Litvínov |
18 |
1 |
1 | 0 |
16 |
39:112 |
-73 |
5 |