Index: openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-manager-procs-postgresql.xql,v
diff -u -r1.2.2.1 -r1.2.2.2
--- openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql	2 Jul 2004 23:13:48 -0000	1.2.2.1
+++ openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql	26 Oct 2004 01:22:27 -0000	1.2.2.2
@@ -35,5 +35,24 @@
     t.name
     </querytext>
   </fullquery>
+
+  <fullquery name="pm::util::subsite_assignees_list_of_lists_not_cached.get_assignees">
+    <querytext>
+      SELECT
+      p.first_names || ' ' || p.last_name as name,
+      p.person_id
+      FROM
+      persons p,
+      acs_rels r,
+      membership_rels mr
+      WHERE
+      r.object_id_one = :user_group_id and
+      mr.rel_id = r.rel_id and
+      p.person_id = r.object_id_two and
+      member_state = 'approved'
+      ORDER BY
+      p.first_names, p.last_name
+    </querytext>
+  </fullquery>
   
 </queryset>