Got error 28 from storage engine SQL=SELECT matches.* ,playground.name AS playground_name,playground.short_name AS playground_short_name FROM jos_joomleague_match AS matches INNER JOIN jos_joomleague_round AS r ON matches.round_id=r.id INNER JOIN jos_joomleague_project_team AS pt1 ON matches.projectteam1_id=pt1.id INNER JOIN jos_joomleague_team AS t1 ON t1.id=pt1.team_id INNER JOIN jos_joomleague_project_team AS pt2 ON matches.projectteam2_id=pt2.id INNER JOIN jos_joomleague_team AS t2 ON t2.id=pt2.team_id LEFT JOIN jos_joomleague_playground AS playground ON playground.id=matches.playground_id WHERE r.project_id=134 AND r.roundcode=1 AND (t1.id=127 OR t2.id=127) AND matches.published=1 GROUP BY matches.id
ORDER BY matches.match_date ASC,matches.match_number
Salibandyn kesäsarja
Sarjataulukko
# | JOUKKUE | O | PTS |
---|---|---|---|
1 | Verkkoverstas | 10 | 30 |
2 | Team A-H-M-A | 10 | 24 |
3 | Team HaiPro | 10 | 15 |
4 | FB Alapiha | 10 | 15 |
5 | Cafe Keidas | 10 | 5 |
6 | Team KalU | 10 | 1 |