select r.rel_id, u.first_names || ' ' || u.last_name as name from acs_rels r, membership_rels mr, cc_users u where r.object_id_one = :group_id and r.rel_type = 'membership_rel' and mr.rel_id = r.rel_id and u.user_id = r.object_id_two [template::list::filter_where_clauses -and -name "members"] [template::list::orderby_clause -orderby -name "members"] select admin_role.pretty_name as admin_role_pretty, member_role.pretty_name as member_role_pretty from acs_rel_roles admin_role, acs_rel_roles member_role where admin_role.role = 'admin' and member_role.role = 'member'; select r.rel_id, u.user_id, u.first_names || ' ' || u.last_name as name, u.email, mr.member_state, (select count(*) from rel_segment_party_map where rel_type = 'admin_rel' and group_id = :group_id and party_id = u.user_id) as member_admin_p from acs_rels r, membership_rels mr, cc_users u where r.object_id_one = :group_id and mr.rel_id = r.rel_id and r.rel_id = mr.rel_id and u.user_id = r.object_id_two [template::list::filter_where_clauses -and -name "members"] [template::list::page_where_clause -and -name "members" -key "r.rel_id"] [template::list::orderby_clause -orderby -name "members"] select mr.member_state as state, count(mr.rel_id) as num_members from membership_rels mr, acs_rels r where r.rel_id = mr.rel_id and r.object_id_one = :group_id and r.rel_type = 'membership_rel' group by mr.member_state