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 =0) 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 =735OR mm.menuid =0) ORDERBYPOSITION, ordering
SELECT id, parent_id,VALUE, name, lft, rgt FROM jos_core_acl_aro_groups WHERE id=23
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 =322 AND(( a.created_by =0)OR( a.state =1 AND( a.publish_up ='0000-00-00 00:00:00'OR a.publish_up <='2021-03-03 21:35:20') AND( a.publish_down ='0000-00-00 00:00:00'OR a.publish_down >='2021-03-03 21:35:20'))OR( a.state =-1))
UPDATE jos_content SET hits =( hits +1) WHERE id='322'
SELECT g.* FROM jos_core_acl_aro_groups AS g INNERJOIN jos_core_acl_groups_aro_map AS gm ON gm.group_id = g.id INNERJOIN jos_core_acl_aro AS ao ON ao.id = gm.aro_id WHERE ao.VALUE='62' ORDERBY g.id
SELECT* FROM jos_modules WHERE access <=0 AND client_id =0 AND( title='YT Surface aerator 15 HP') AND published =1 ORDERBY ordering LIMIT1
SELECT* FROM jos_modules WHERE access <=0 AND client_id =0 AND( title='Chat WA All') AND published =1 ORDERBY ordering LIMIT1
SELECT guest, usertype, client_id FROM jos_session WHERE client_id =0