SELECT folder AS type, 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 = 1) 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 = 1OR mm.menuid = 0) ORDERBY position, ordering
11 legacy queries logged
SELECT * FROM jos_adsmanager_config
SELECTDISTINCT a.*, p.name AS parent, p.id AS parentid, c.name AS cat, c.id AS catid, u.name AS user FROM jos_adsmanager_ads AS a LEFTJOIN jos_adsmanager_adcat AS adcat ON adcat.adid = a.id LEFTJOIN jos_users AS u ON a.userid = u.id LEFTJOIN jos_adsmanager_categories AS c ON adcat.catid = c.id LEFTJOIN jos_adsmanager_categories AS p ON c.parent = p.id WHERE a.id=25 AND c.published LIMIT1
SELECT c.* FROM jos_adsmanager_categories AS c WHERE c.published = 1 ORDERBY c.parent,c.ordering
SELECT * FROM jos_adsmanager_positions WHERE1
SELECT f.* FROM jos_adsmanager_fields AS f WHERE f.pos != -1 AND f.published = 1 ORDERBY f.posorder
SELECT * FROM jos_adsmanager_field_values ORDERBY ordering
UPDATE jos_adsmanager_ads SET views = LAST_INSERT_ID(views+1) WHERE id = 25
SELECT c.* FROM jos_adsmanager_categories AS c WHERE c.published = 1 ORDERBY c.parent,c.ordering
SELECT c.*, (SELECT count(*) FROM jos_adsmanager_ads a LEFTJOIN jos_adsmanager_adcat AS adcat ON adcat.adid = a.id WHERE adcat.catid = c.id AND a.published = 1)AS num_ads FROM jos_adsmanager_categories AS c WHERE c.published = 1 ORDERBY c.parent,c.ordering
SELECT a.id,a.views, a.ad_headline, a.category, a.date_created,p.id AS parentid,p.name AS parent,c.id AS catid, c.name AS cat FROM jos_adsmanager_ads AS a LEFTJOIN jos_adsmanager_adcat AS adcat ON adcat.adid = a.id LEFTJOIN jos_users AS u ON a.userid = u.id LEFTJOIN jos_adsmanager_categories AS c ON adcat.catid = c.id LEFTJOIN jos_adsmanager_categories AS p ON c.parent = p.id WHERE c.published = 1 AND a.published = 1 GROUPBY a.id ORDERBY a.date_created DESC ,a.id DESC LIMIT0, 10