Disk full (/var/tmp/#sql_576_0); waiting for someone to free some space... 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