SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDERBY ordering
SELECT * FROM jos_migration_backlinks WHERE url LIKE'option=com\_jevents&task=year.listevents&year=2012&month=08&day=13&Itemid=13%'OR sefurl LIKE'option=com\_jevents&task=year.listevents&year=2012&month=08&day=13&Itemid=13%'
SELECT * FROM jos_migration_backlinks WHERE url LIKE'index.php?option=com\_jevents&task=year.listevents&year=2012&month=08&day=13&Itemid=13%'OR sefurl LIKE'index.php?option=com\_jevents&task=year.listevents&year=2012&month=08&day=13&Itemid=13%'
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 tl.*, ju.name AS jname, ju.username FROM jos_jev_users AS tl LEFTJOIN jos_users AS ju ON tl.user_id=ju.id WHERE ju.id IN(0)
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 rpt.rp_id
FROM jos_jevents_repetition AS rpt
LEFTJOIN jos_jevents_vevent AS ev ON rpt.eventid = ev.ev_id
LEFTJOIN jos_jevents_icsfile AS icsf ON icsf.ics_id=ev.icsid
LEFTJOIN jos_jevents_vevdetail AS det ON det.evdet_id = rpt.eventdetail_id
LEFTJOIN jos_jevents_rrule AS rr ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,13)
AND rpt.endrepeat >= '2012-01-01 00:00:00' AND rpt.startrepeat <= '2012-12-31 23:59:59' AND ev.state=1
AND ev.access <= 0 AND icsf.state=1 AND icsf.access <= 0
LEFTJOIN jos_jevents_vevent AS ev ON rpt.eventid = ev.ev_id
LEFTJOIN jos_jevents_icsfile AS icsf ON icsf.ics_id=ev.icsid
LEFTJOIN jos_jevents_vevdetail AS det ON det.evdet_id = rpt.eventdetail_id
LEFTJOIN jos_jevents_rrule AS rr ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,13)
AND rpt.endrepeat >= '2012-01-01 00:00:00' AND rpt.startrepeat <= '2012-12-31 23:59:59' AND ev.state=1
AND ev.access <= 0 AND icsf.state=1 AND icsf.access <= 0 ORDERBY rpt.startrepeat ASC LIMIT10
SELECT * FROM jos_rereplacer
WHERE published = 1
ORDERBY ordering
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 = 13OR mm.menuid = 0) ORDERBY position, ordering