SELECT m.*, c.`option`AS component FROM pb_menu AS m LEFTJOIN pb_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDERBY m.sublevel, m.parent, m.ordering
SELECT template FROM pb_templates_menu WHERE client_id = 0 AND(menuid = 0OR menuid = 30) ORDERBY menuid DESC LIMIT0, 1
SELECT id, title, module, position, content, showtitle, control, params FROM pb_modules AS m LEFTJOIN pb_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 = 30OR mm.menuid = 0) ORDERBY position, ordering
SELECT m.*, c.`option`AS component FROM pb_menu AS m LEFTJOIN pb_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDERBY m.sublevel, m.parent, m.ordering