SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDERBY ordering
SELECT template FROM jos_templates_menu WHERE client_id = 0 AND(menuid = 0OR menuid = 60) ORDERBY menuid DESC LIMIT0, 1
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug FROM jos_phocagallery_categories AS c WHERE c.id = 5 LIMIT0, 1
SELECT * FROM jos_phocagallery_categories WHERE id = 0 AND published = 1 AND id <> 5 ORDERBY ordering ASC LIMIT0, 1
SELECT c.* FROM jos_phocagallery_categories AS c WHERE c.parent_id = 5 AND c.published = 1 AND c.id <> 5 ORDERBY c.ordering ASC
SELECT a.* FROM jos_phocagallery AS a WHERE a.catid = 5 AND published = 1 ORDERBY a.ordering ASC LIMIT0, 100
SELECT a.* FROM jos_phocagallery AS a WHERE a.catid = 5 AND published = 1 ORDERBY a.ordering ASC
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 = 60OR mm.menuid = 0) ORDERBY position, ordering