oracle8.1.6 select count(*) from dotlrn_communities_not_closed dotlrn_communities select dotlrn_communities.community_id, dotlrn_communities.community_type, dotlrn_communities.pretty_name, dotlrn_communities.description, dotlrn_communities.package_id, dotlrn_community.url(dotlrn_communities.community_id) as url, (select count(*) from dual where exists (select 1 from dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id)) as member_p, decode(acs_permission.permission_p(:user_id, dotlrn_communities.community_id, 'admin'),'f',0,1) as admin_p, (select community_type from dotlrn_community_types where supertype = 'dotlrn_community' start with community_type = dotlrn_communities.community_type connect by community_type = prior supertype) as root_community_type from dotlrn_communities_not_closed dotlrn_communities order by root_community_type, dotlrn_communities.community_type, dotlrn_communities.pretty_name select dotlrn_communities.community_id, dotlrn_communities.community_type, dotlrn_communities.pretty_name, dotlrn_communities.description, dotlrn_communities.package_id, dotlrn_community.url(dotlrn_communities.community_id) as url, (select count(*) from dual where exists (select 1 from dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id)) as member_p, decode(acs_permission.permission_p(:user_id, dotlrn_communities.community_id, 'admin'),'f',0,1) as admin_p, (select community_type from dotlrn_community_types where supertype = 'dotlrn_community' start with community_type = dotlrn_communities.community_type connect by community_type = prior supertype) as root_community_type from dotlrn_active_comms_not_closed dotlrn_communities order by root_community_type, dotlrn_communities.community_type, dotlrn_communities.pretty_name select count(*) from dotlrn_communities_not_closed dotlrn_communities where dotlrn_communities.community_type = :community_type select dotlrn_communities.community_id, dotlrn_communities.community_type, dotlrn_communities.pretty_name, dotlrn_communities.description, dotlrn_communities.package_id, dotlrn_community.url(dotlrn_communities.community_id) as url, (select count(*) from dual where exists (select 1 from dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id)) as member_p, decode(acs_permission.permission_p(:user_id, dotlrn_communities.community_id, 'admin'),'f',0,1) as admin_p, (select community_type from dotlrn_community_types where supertype = 'dotlrn_community' start with community_type = dotlrn_communities.community_type connect by community_type = prior supertype) as root_community_type from dotlrn_communities_not_closed dotlrn_communities where dotlrn_communities.community_type = :community_type order by root_community_type, dotlrn_communities.pretty_name select dotlrn_communities.community_id, dotlrn_communities.community_type, dotlrn_communities.pretty_name, dotlrn_communities.description, dotlrn_communities.package_id, dotlrn_community.url(dotlrn_communities.community_id) as url, (select count(*) from dual where exists (select 1 from dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id)) as member_p, decode(acs_permission.permission_p(:user_id, dotlrn_communities.community_id, 'admin'),'f',0,1) as admin_p, (select community_type from dotlrn_community_types where supertype = 'dotlrn_community' start with community_type = dotlrn_communities.community_type connect by community_type = prior supertype) as root_community_type from dotlrn_active_comms_not_closed dotlrn_communities where dotlrn_communities.community_type = :community_type order by root_community_type, dotlrn_communities.pretty_name