SELECT folder ASTYPE, element AS name, params FROM obtf_plugins WHERE published >=1 AND access <=0 ORDERBY ordering
SELECT template FROM obtf_templates_menu WHERE client_id =0 AND(menuid =0OR menuid =17) ORDERBY menuid DESC LIMIT0,1
SELECT c.id
FROM obtf_categories AS c LEFTJOIN obtf_categories AS p ON p.id=c.parent_id LEFTJOIN obtf_categories AS gp ON gp.id=p.parent_id LEFTJOIN obtf_categories AS ggp ON ggp.id=gp.parent_id
LEFTJOIN obtf_jevents_vevent AS ev ON rpt.eventid = ev.ev_id
LEFTJOIN obtf_jevents_icsfile AS icsf ON icsf.ics_id=ev.icsid
LEFTJOIN obtf_jevents_vevdetail AS det ON det.evdet_id = rpt.eventdetail_id
LEFTJOIN obtf_jevents_rrule AS rr ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,15)
AND rpt.endrepeat >='2012-05-06 00:00:00' AND rpt.startrepeat <='2012-05-06 23:59:59' AND ev.state=1
AND ev.access <=0 AND icsf.state=1 AND icsf.access <=0
SELECT id, title, module,POSITION, content, showtitle, control, params FROM obtf_modules AS m LEFTJOIN obtf_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 =17OR mm.menuid =0) ORDERBYPOSITION, ordering
SELECT parent, menutype, ordering FROM obtf_menu WHERE id =17 LIMIT1
SELECTCOUNT(*) FROM obtf_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <='0' AND parent=0 AND ordering <16
SELECT id, folder, element, published,TYPE, params, CONCAT_WS('/',folder,element)AS lookup, name