Index: openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql	15 Jul 2002 20:12:46 -0000	1.1
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql	17 Oct 2002 12:59:53 -0000	1.1.2.1
@@ -36,11 +36,11 @@
                  acs_rels,
                  membership_rels
             where parties.party_id = users.user_id
+            and member_state not in ('banned','deleted','rejected')
             and users.user_id = persons.person_id
             and persons.person_id = acs_rels.object_id_two
             and acs_rels.object_id_one = acs__magic_object_id('registered_users')
             and acs_rels.rel_id = membership_rels.rel_id
-            and membership_rels.member_state = 'approved'
             and not exists (select 1
                             from acs_rels a,
                                  dotlrn_user_types