Added by anonymous on 2008-10-16 14:37:04 Download/View
- SELECT access.allow
- FROM (uj_acl_aros AS aro_node, uj_acl_acos AS aco_node)
- LEFT JOIN uj_acl_aros AS aro_branch ON (aro_node.lft >= aro_branch.lft AND aro_node.lft <= aro_branch.rgt)
- LEFT JOIN uj_acl_acos AS aco_branch >= aco_branch.lft AND aco_node.lft <= aco_branch.rgt)
- INNER JOIN uj_acl_access AS access ON (aro_branch.id = access.aro_id AND aco_branch.id = access.aco_id)
- WHERE aro_node.name = 'Bob' AND aco_node.name = 'Website'
- ORDER BY aro_branch.rgt ASC, aco_branch.rgt ASC
- LIMIT 1