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 = 1) 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 = 62 AND a.access <= 0 AND(( a.created_by = 0)OR( a.state = 1OR a.state = -1) AND( a.publish_up = '0000-00-00 00:00:00'OR a.publish_up <= '2024-10-09 23:18:02') AND( a.publish_down = '0000-00-00 00:00:00'OR a.publish_down >= '2024-10-09 23:18:02'))
UPDATE jos_content SET hits = ( hits + 1) WHERE id='62'