SELECT folder ASTYPE, 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 =28) ORDERBY menuid DESC LIMIT0,1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title ASSECTION,CASEWHENCHAR_LENGTH(a.alias)THEN CONCAT_WS(":", a.id, a.alias)ELSE a.id ENDAS slug,CASEWHENCHAR_LENGTH(cc.alias)THEN CONCAT_WS(":", cc.id, cc.alias)ELSE cc.id ENDAS 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 =17 AND(( a.created_by =0)OR( a.state =1 AND( a.publish_up ='0000-00-00 00:00:00'OR a.publish_up <='2025-07-31 04:14:20') AND( a.publish_down ='0000-00-00 00:00:00'OR a.publish_down >='2025-07-31 04:14:20'))OR( a.state =-1))
UPDATE jos_content SET hits =( hits +1) WHERE id='17'
SELECT* FROM jos_ignitegallery WHERE id =1
SELECT template FROM jos_templates_menu WHERE client_id =0 AND menuid =0