SELECT folder ASTYPE, element AS name, params FROM jos_plugins WHERE published >=1 AND access <=0 ORDERBY ordering
SELECT setting,VALUE FROM jos_jfbconnect_config
SELECT`value`
FROM`jos_admintools_storage`
WHERE`key`='cparams'
SELECT* FROM jos_redj WHERE((('/component/jevents/search.form/2020/07/03/-'REGEXPBINARY fromurl)>0 AND case_sensitive<>'0')OR(('/component/jevents/search.form/2020/07/03/-'REGEXP fromurl)>0 AND case_sensitive='0')) AND published='1' 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 =0OR mm.menuid =0) ORDERBYPOSITION, ordering
SELECT c.id
FROM jos_categories AS c LEFTJOIN jos_categories AS p ON p.id=c.parent_id LEFTJOIN jos_categories AS gp ON gp.id=p.parent_id LEFTJOIN jos_categories AS ggp ON ggp.id=gp.parent_id
WHERE c.access <=0
AND c.published =1
AND c.SECTION='com_jevents'
SELECT j_user_id FROM jos_jfbconnect_user_map WHERE fb_user_id=''
SELECT*, RAND()AS ordering FROM jos_banner WHERE showBanner =1 AND(imptotal =0OR impmade < imptotal) AND catid =8 ORDERBY sticky DESC, ordering LIMIT0,1
UPDATE jos_banner SET impmade = impmade +1 WHERE bid =30
SELECT a.id, a.alias AS username, a.title AS fullname, a.catid, a.sectionid, a.introtext AS intro, u.email AS email, u.id AS user_id,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 FROM jos_content AS a LEFTJOIN jos_categories AS cc ON cc.id = a.catid LEFTJOIN jos_users AS u ON u.username = a.alias WHERE a.sectionid =15 AND a.state =1