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 =27) 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 =15 AND(( a.created_by =0)OR( a.state =1 AND( a.publish_up ='0000-00-00 00:00:00'OR a.publish_up <='2022-05-22 06:47:56') AND( a.publish_down ='0000-00-00 00:00:00'OR a.publish_down >='2022-05-22 06:47:56'))OR( a.state =-1))
UPDATE jos_content SET hits =( hits +1) WHERE id='15'
SELECT params FROM jos_components AS c WHERE c.OPTION='com_widgetkit'
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 =27OR mm.menuid =0) ORDERBYPOSITION, ordering
SELECT*, RAND()AS ordering FROM jos_banner WHERE showBanner =1 AND(imptotal =0OR impmade < imptotal) AND cid =1 AND catid =33 ORDERBY sticky DESC, ordering LIMIT0,1
UPDATE jos_banner SET impmade = impmade +1 WHERE bid =8