postgresql7.1 select distinct h.community_key, h.community_id, h.pretty_name, h.parent_community_id from dotlrn_communities h, dotlrn_clubs c where (h.parent_community_id is not null or c.club_id = h.community_id) and upper(substr(h.pretty_name, 1, 1)) = :section order by h.pretty_name select distinct h.community_key, h.community_id, h.pretty_name, h.parent_community_id from dotlrn_communities h, dotlrn_clubs c where (h.parent_community_id is not null or c.club_id = h.community_id) and upper(substr(h.pretty_name, 1, 1)) not in ('[join $dimension_list "\', \'"]') order by h.pretty_name select dotlrn_communities_full.community_key, dotlrn_communities_full.community_id, dotlrn_communities_full.pretty_name from dotlrn_classes, dotlrn_communities_full where dotlrn_communities_full.community_type = dotlrn_classes.class_key and upper(substr(dotlrn_communities_full.pretty_name, 1, 1)) = :section order by dotlrn_communities_full.pretty_name select dotlrn_communities_full.community_key, dotlrn_communities_full.community_id, dotlrn_communities_full.pretty_name from dotlrn_classes, dotlrn_communities_full where dotlrn_communities_full.community_type = dotlrn_classes.class_key and upper(substr(dotlrn_communities_full.pretty_name, 1, 1)) not in ('[join $dimension_list "\', \'"]') order by dotlrn_communities_full.pretty_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)) = :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