sql:SELECT * FROM sys_group_right rg
JOIN sys_navi n ON (n.user_right_id = rg.right_id)
WHERE rg.group_id = 4 AND n.active = 1 AND n.topbottom = 0 AND (n.parent_id IS NULL OR trim(n.parent_id) = '') AND n.lang_id = "de" ORDER BY n.position ASC
- Startseite
- Datenbereich
-
