SELECT folder ASTYPE, element AS name, params FROM jos_plugins WHERE published >=1 AND access <=0 ORDERBY ordering
SELECT id, parent_id,VALUE, name, lft, rgt FROM jos_core_acl_aro_groups WHERE id=23
SELECT template FROM jos_templates_menu WHERE client_id =0 AND(menuid =0OR menuid =32) ORDERBY menuid DESC LIMIT0,1
SELECT id, title, module,POSITION, content, showtitle, control, params FROM jos_modules AS m LEFTJOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published =1 AND m.access <=0 AND m.client_id =0 AND( mm.menuid =32OR mm.menuid =0) ORDERBYPOSITION, ordering
SELECT* FROM jos_menu WHERE menutype='mainmenu' AND published=1 ORDERBY ordering