| Calendar |
|
JEvents v1.4.0 Copyright © 2006 |
MySQL server has gone away SQL=SELECT m.id,m.name,m.link,m.parent,m.browserNav,m.type, sum(case when p.published=1 then 1 else 0 end) as child_count\nFROM jos_menu AS m\nLEFT JOIN jos_menu AS p ON p.parent = m.id\nWHERE m.menutype=\'mainmenu\' AND m.published=\'1\' AND m.access <= 0\nGROUP BY m.id ORDER BY m.parent, m.ordering