SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDERBY ordering
SELECT m.*, c.`option`AS component FROM jos_menu AS m LEFTJOIN jos_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDERBY m.sublevel, m.parent, m.ordering
SELECT template FROM jos_templates_menu WHERE client_id = 0 AND(menuid = 0OR menuid = 59) 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 = 59OR mm.menuid = 0) ORDERBY position, ordering