Disk full (/var/tmp/#sql-temptable-533-55a8a-65a3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt FROM jos_menu AS m LEFT JOIN jos_menu AS p ON p.parent = m.id WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= 0 GROUP BY m.id ORDER BY m.parent, m.ordering