Got error 28 from storage engine SQL=SELECT a.*, u.name, u.username, cc.image AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,'link' as link
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
LEFT JOIN jos_users AS u ON u.id = a.created_by
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 11:08:02')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 11:08:02' )
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND ( a.catid=1 OR a.catid=35 OR a.catid=25 OR a.catid=36 OR a.catid=37 OR a.catid=38 OR a.catid=41 OR a.catid=42 OR a.catid=43 OR a.catid=44 OR a.catid=45 OR a.catid=46 OR a.catid=47 OR a.catid=48 OR a.catid=37 OR a.catid=49 OR a.catid=50 OR a.catid=51 OR a.catid=52 OR a.catid=53 OR a.catid=54 OR a.catid=55 OR a.catid=56 OR a.catid=57 OR a.catid=58 OR a.catid=59 )
AND ( a.sectionid=1 OR a.sectionid=3 OR a.sectionid=4 OR a.sectionid=5 OR a.sectionid=6 OR a.sectionid=7 OR a.sectionid=10 OR a.sectionid=8 )
AND ((TO_DAYS('2012-01-28') - TO_DAYS(a.created)) <= '1200')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created desc
limit 0,10






