oracle8.1.6 select l.link_id from category_links l, categories c where l.link_id in ([join $link_id ,]) and acs_permission.permission_p(c.tree_id,:user_id,'category_tree_write') = 't' and ((l.from_category_id = :category_id and l.to_category_id = c.category_id) or (l.from_category_id = c.category_id and l.to_category_id = :category_id))