Got error 28 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, d1.name as divhome, d2.name as divaway,
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 jos_joomleague_match AS m
INNER JOIN jos_joomleague_round AS r ON m.round_id=r.id
LEFT JOIN jos_joomleague_project_team AS tt1 ON m.projectteam1_id=tt1.id
LEFT JOIN jos_joomleague_project_team AS tt2 ON m.projectteam2_id=tt2.id
LEFT JOIN jos_joomleague_team AS t1 ON t1.id=tt1.team_id
LEFT JOIN jos_joomleague_team AS t2 ON t2.id=tt2.team_id
LEFT JOIN jos_joomleague_division AS d1 ON tt1.division_id=d1.id
LEFT JOIN jos_joomleague_division AS d2 ON tt2.division_id=d2.id
LEFT JOIN jos_joomleague_playground AS playground ON playground.id=m.playground_id WHERE m.published=1
AND r.id=1268
AND r.project_id=142
AND (
d1.id=131 OR
d1.parent_id=131 OR
d2.id=131 OR
d2.parent_id=131
) GROUP BY m.id ORDER BY m.match_date ASC,m.match_number