Index: openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql,v diff -u -r1.13.2.1 -r1.13.2.2 --- openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql 17 Oct 2002 12:59:53 -0000 1.13.2.1 +++ openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql 13 Mar 2003 14:25:24 -0000 1.13.2.2 @@ -36,6 +36,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