Index: openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql 4 Dec 2002 09:51:04 -0000 1.2 +++ openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql 29 May 2003 18:05:01 -0000 1.3 @@ -52,6 +52,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