SELECT folder ASTYPE, element AS name, params FROM jos_plugins WHERE published >=1 AND access <=0 ORDERBY ordering
SELECT`value`
FROM`jos_admintools_storage`
WHERE`key`='cparams'
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* FROM jos_k2_categories WHERE published=1 AND trash=0 AND access<=0
SELECT* FROM jos_k2_items WHERE id=19 LIMIT0,1
SELECT* FROM jos_k2_categories WHERE id=2 LIMIT0,1
SELECT* FROM jos_k2_attachments WHERE itemID=19
SELECTCOUNT(*) FROM jos_k2_comments WHERE published=1 AND itemID=19
UPDATE jos_k2_items SET hits =( hits +1) WHERE id='19'