select group_name from groups where group_id=:group_instance select gmm.member_id from group_member_map gmm, acs_users_all aua where aua.user_id=gmm.member_id and gmm.group_id=:group_instance select aua.user_id from acs_users_all aua, acs_rels ar where aua.user_id > 0 and aua.user_id not in ([join $members_list ","]) and aua.user_id=ar.object_id_two and ar.object_id_one = :community_id select gmm.member_id from group_member_map gmm where group_id=:group_instance and container_id=:group_instance select gmm.member_id from group_member_map gmm where container_id=:parent_instance and not (member_id in ([join $members_list ","])) and not (gmm.member_id in ([join $not_allowed ","])) select dut.type as type, aua.username, aua.first_names, aua.last_name, aua.user_id from dotlrn_user_types dut, group_member_index gmi, acs_users_all aua where dut.group_id=gmi.group_id and gmi.member_id=aua.user_id and aua.user_id in ([join $members_list ","]); select dut.type as type, aua.username, aua.first_names, aua.last_name, aua.user_id from dotlrn_user_types dut, group_member_index gmi, acs_users_all aua where dut.group_id=gmi.group_id and gmi.member_id=aua.user_id and aua.user_id in ([join $not_members_list ","]); select object_id_one as parent_instance from acs_rels where object_id_two=:group_instance and rel_type='composition_rel' select gmm.member_id from imsld_roles ir1, imsld_rolesi ir2, acs_rels ar, group_member_map gmm where ir1.role_id=:role and ir1.parent_role_id=ir2.parent_role_id and ir2.role_id!=ir1.role_id and ar.object_id_one=ir2.item_id and ar.rel_type='imsld_role_group_rel' and gmm.group_id=ar.object_id_two group by member_id