Got error 28 from storage engine SQL=SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM r3whu_menu AS m
LEFT JOIN r3whu_menu AS p ON p.parent_id = m.id
WHERE m.menutype='mainmenu' AND m.published='1'
GROUP BY m.id ORDER BY m.home DESC,m.parent_id, m.lft ASC
