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 = 43) ORDERBY menuid DESC LIMIT0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access FROM jos_content AS a LEFTJOIN jos_categories AS cc ON cc.id = a.catid LEFTJOIN jos_sections AS s ON s.id = cc.section AND s.scope = "content" LEFTJOIN jos_users AS u ON u.id = a.created_by LEFTJOIN jos_groups AS g ON a.access = g.id WHERE a.id = 237 AND(( a.created_by = 0)OR( a.state = 1 AND( a.publish_up = '0000-00-00 00:00:00'OR a.publish_up <= '2024-12-04 19:46:16') AND( a.publish_down = '0000-00-00 00:00:00'OR a.publish_down >= '2024-12-04 19:46:16'))OR( a.state = -1))
UPDATE jos_content SET hits = ( hits + 1) WHERE id='237'
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 = 43OR mm.menuid = 0) ORDERBY position, ordering