Index: openacs-4/packages/dotlrn/www/admin/users-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/Attic/users-oracle.xql,v
diff -u -N -r1.13 -r1.14
--- openacs-4/packages/dotlrn/www/admin/users-oracle.xql	9 Jul 2002 12:39:33 -0000	1.13
+++ openacs-4/packages/dotlrn/www/admin/users-oracle.xql	4 Dec 2002 09:51:04 -0000	1.14
@@ -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')
                  minus
                   select acs_rels.object_id_two
                   from acs_rels, dotlrn_user_types