Got error -1 from storage engine SQL=SELECT m.*,
DATE_FORMAT(m.time_present,"%H:%i") time_present,
playground.name AS playground_name,
playground.short_name AS playground_short_name,
tt1.project_id,
CASE WHEN CHAR_LENGTH(t1.alias) AND CHAR_LENGTH(t2.alias) THEN CONCAT_WS(':', m.id, CONCAT_WS("_", t1.alias, t2.alias)) ELSE m.id END AS slug
FROM newing_joomleague_match AS m
INNER JOIN newing_joomleague_round AS r ON m.round_id=r.id
LEFT JOIN newing_joomleague_project_team AS tt1 ON m.projectteam1_id=tt1.id
LEFT JOIN newing_joomleague_project_team AS tt2 ON m.projectteam2_id=tt2.id
LEFT JOIN newing_joomleague_team AS t1 ON t1.id=tt1.team_id
LEFT JOIN newing_joomleague_team AS t2 ON t2.id=tt2.team_id
LEFT JOIN newing_joomleague_division AS d1 ON tt1.division_id=d1.id
LEFT JOIN newing_joomleague_division AS d2 ON tt2.division_id=d2.id
LEFT JOIN newing_joomleague_playground AS playground ON playground.id=m.playground_id WHERE r.roundcode=2 AND r.project_id=2 GROUP BY m.id ORDER BY m.match_date ASC, m.match_number
Rezultatet - Ndeshja 2-te (10.09.2008)
6 Team(s) not playing:Shqiperi, Portugali, Malta, Suedi, Hungari, Danimarke