SELECT folder ASTYPE, element AS name, params FROM jos_plugins WHERE published >=1 AND access <=0 ORDERBY ordering
SELECT template FROM jos_templates_menu WHERE client_id =0 AND(menuid =0OR menuid =146) ORDERBY menuid DESC LIMIT0,1
SELECTUSER.id,USER.name, board.cnt FROM(SELECT otc_volunteer AS id,COUNT(otc_volunteer)AS cnt FROM jos_toc_magazines WHERE otc_volunteer !=0 AND otc_state ='corrected' GROUPBY otc_volunteer)AS board LEFTJOIN jos_users ASUSER ONUSER.id = board.id ORDERBYUSER.name ASC
SELECTUSER.id,USER.name, board.cnt FROM(SELECT otc_volunteer AS id,COUNT(otc_volunteer)AS cnt FROM jos_toc_magazines WHERE otc_volunteer !=0 AND otc_state ='corrected' GROUPBY otc_volunteer)AS board LEFTJOIN jos_users ASUSER ONUSER.id = board.id ORDERBYUSER.name ASC
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 =146OR mm.menuid =0) ORDERBYPOSITION, ordering
SELECT guest, usertype, client_id,DATA FROM jos_session WHERE client_id =0