oracle8.1.6 select dotlrn_communities.*, dotlrn_community.url(dotlrn_communities.community_id) as url, decode(dotlrn_communities.community_type, 'dotlrn_community', 'dotlrn_community', 'dotlrn_club', 'dotlrn_club', 'dotlrn_class_instance') as simple_community_type, tree.tree_level(dotlrn_communities.tree_sortkey) as tree_level, nvl((select tree.tree_level(dotlrn_community_types.tree_sortkey) from dotlrn_community_types where dotlrn_community_types.community_type = dotlrn_communities.community_type), 0) as community_type_level, acs_permission.permission_p(dotlrn_communities.community_id, :user_id, 'admin') as admin_p from dotlrn_communities, dotlrn_member_rels_approved where dotlrn_communities.community_id = dotlrn_member_rels_approved.community_id and dotlrn_member_rels_approved.user_id = :user_id order by dotlrn_communities.tree_sortkey