oracle8.1.6 select dotlrn_users.user_id, dotlrn_users.first_names, dotlrn_users.last_name, dotlrn_users.email, dotlrn_privacy.guest_p(dotlrn_users.user_id) as guest_p, acs_permission.permission_p(:root_object_id, dotlrn_users.user_id, 'admin') as site_wide_admin_p from dotlrn_users where dotlrn_users.type = :type and upper(substr(dotlrn_users.last_name, 1, 1)) = :section order by dotlrn_users.last_name select dotlrn_users.user_id, dotlrn_users.first_names, dotlrn_users.last_name, dotlrn_users.email, dotlrn_privacy.guest_p(dotlrn_users.user_id) as guest_p, acs_permission.permission_p(:root_object_id, dotlrn_users.user_id, 'admin') as site_wide_admin_p from dotlrn_users where dotlrn_users.type = :type and upper(substr(dotlrn_users.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]') order by dotlrn_users.last_name select users.user_id, persons.first_names, persons.last_name, parties.email, 'f' as guest_p, acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p from parties, users, persons, acs_rels, membership_rels where parties.party_id = users.user_id and member_state not in ('banned','deleted','rejected') and users.user_id = persons.person_id and persons.person_id = acs_rels.object_id_two and acs_rels.object_id_one = acs.magic_object_id('registered_users') and acs_rels.rel_id = membership_rels.rel_id and users.email_verified_p = 't' and not exists (select 1 from acs_rels a, dotlrn_user_types where a.object_id_one = dotlrn_user_types.group_id and a.object_id_two = acs_rels.object_id_two) and upper(substr(persons.last_name, 1, 1)) = :section order by persons.last_name select users.user_id, persons.first_names, persons.last_name, parties.email, 'f' as guest_p, acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p from parties, users, persons, acs_rels, membership_rels where parties.party_id = users.user_id and users.user_id = persons.person_id and persons.person_id = acs_rels.object_id_two and acs_rels.rel_id = membership_rels.rel_id and membership_rels.member_state = 'approved' and not exists (select 1 from acs_rels a, dotlrn_user_types where a.object_id_one = dotlrn_user_types.group_id and a.object_id_two = acs_rels.object_id_two) and upper(substr(person.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]') order by persons.last_name select users.user_id, persons.first_names, persons.last_name, parties.email, 'f' as guest_p, acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p from parties, users, persons, acs_rels, membership_rels where parties.party_id = users.user_id and users.user_id = persons.person_id and persons.person_id = acs_rels.object_id_two and acs_rels.object_id_one = acs.magic_object_id('registered_users') and acs_rels.rel_id = membership_rels.rel_id and membership_rels.member_state = 'banned' and upper(substr(persons.last_name, 1, 1)) = :section order by persons.last_name select users.user_id, persons.first_names, persons.last_name, parties.email, 'f' as guest_p, acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p from parties, users, persons, acs_rels, membership_rels where parties.party_id = users.user_id and users.user_id = persons.person_id and persons.person_id = acs_rels.object_id_two and acs_rels.object_id_one = acs.magic_object_id('registered_users') and acs_rels.rel_id = membership_rels.rel_id and membership_rels.member_state = 'banned' and upper(substr(person.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]') order by persons.last_name