Index: openacs-4/packages/dotlrn/www/admin/users-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/Attic/users-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn/www/admin/users-postgresql.xql	11 Jul 2002 15:54:13 -0000	1.2
+++ openacs-4/packages/dotlrn/www/admin/users-postgresql.xql	4 Dec 2002 09:51:04 -0000	1.3
@@ -7,8 +7,11 @@
         <querytext>
             select count(*)
             from (select acs_rels.object_id_two
-                  from acs_rels
+                  from acs_rels, membership_rels
                   where acs_rels.object_id_one = (select acs__magic_object_id('registered_users') from dual)
+                  and acs_rels.rel_id = membership_rels.rel_id
+                  and membership_rels.member_state
+                      not in ('banned','deleted','rejected')
                   and acs_rels.object_id_two not in (                  
                       select acs_rels.object_id_two
                              from acs_rels,