oracle8.1.6 select count(*) from dotlrn_class_instances_full, dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id select dotlrn_class_instances_full.*, dotlrn_member_rels_full.role, dotlrn_member_rels_full.member_state, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full, dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_class_instances_full.*, dotlrn_member_rels_full.role, dotlrn_member_rels_full.member_state, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full, dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_class_instances_full.department_key = :member_department_key and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_class_instances_full.*, dotlrn_member_rels_full.role, dotlrn_member_rels_full.member_state, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full, dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_class_instances_full.term_id = :member_term_id and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_class_instances_full.*, dotlrn_member_rels_full.role, dotlrn_member_rels_full.member_state, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full, dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_class_instances_full.department_key = :member_department_key and dotlrn_class_instances_full.term_id = :member_term_id and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_clubs_full.*, dotlrn_member_rels_full.role, dotlrn_member_rels_full.member_state, acs_permission.permission_p(dotlrn_clubs_full.club_id, :user_id, 'admin') as admin_p from dotlrn_clubs_full, dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_clubs_full.club_id order by dotlrn_clubs_full.pretty_name, dotlrn_clubs_full.community_key select count(*) from dotlrn_class_instances_full where dotlrn_class_instances_full.join_policy <> 'closed' and not 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_class_instances_full.class_instance_id) select dotlrn_class_instances_full.*, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full where dotlrn_class_instances_full.join_policy <> 'closed' and not 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_class_instances_full.class_instance_id) order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_class_instances_full.*, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full where dotlrn_class_instances_full.department_key = :non_member_department_key and dotlrn_class_instances_full.join_policy <> 'closed' and not 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_class_instances_full.class_instance_id) order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_class_instances_full.*, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full where dotlrn_class_instances_full.term_id = :non_member_term_id and dotlrn_class_instances_full.join_policy <> 'closed' and not 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_class_instances_full.class_instance_id) order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_class_instances_full.*, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full where dotlrn_class_instances_full.department_key = :non_member_department_key and dotlrn_class_instances_full.term_id = :non_member_term_id and dotlrn_class_instances_full.join_policy <> 'closed' and not 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_class_instances_full.class_instance_id) order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_clubs_full.*, acs_permission.permission_p(dotlrn_clubs_full.club_id, :user_id, 'admin') as admin_p from dotlrn_clubs_full where dotlrn_clubs_full.join_policy <> 'closed' and not 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_clubs_full.club_id) order by dotlrn_clubs_full.pretty_name, dotlrn_clubs_full.community_key