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.2.1 -r1.1.2.2 --- openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql 17 Oct 2002 12:59:53 -0000 1.1.2.1 +++ openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql 13 Mar 2003 14:25:24 -0000 1.1.2.2 @@ -41,6 +41,7 @@ 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 users.email_verified_p = 't' and not exists (select 1 from acs_rels a, dotlrn_user_types