Index: openacs-4/packages/dotlrn/tcl/community-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/tcl/community-procs.xql,v
diff -u -N -r1.81.2.1.4.2 -r1.81.2.1.4.3
--- openacs-4/packages/dotlrn/tcl/community-procs.xql	13 May 2004 15:08:26 -0000	1.81.2.1.4.2
+++ openacs-4/packages/dotlrn/tcl/community-procs.xql	20 May 2004 05:08:36 -0000	1.81.2.1.4.3
@@ -140,16 +140,11 @@
                    dotlrn_member_rels_approved.user_id,
                    acs_users_all.first_names,
                    acs_users_all.last_name,
-                   acs_users_all.email
+                   acs_users_all.email,
                   (select count(*) 
                    from   acs_rels 
                    where  rel_type = 'user_portrait_rel' 
-                   and    object_id_one = dotlrn_member_rels_approved.user_id) as portrait_p,
-                  (select count(*) 
-                   from   acs_attribute_values 
-                   where  object_id = dotlrn_member_rels_approved.user_id
-                   and    attribute_id = :bio_attribute_id 
-                   and    attr_value != '') as bio_p
+                   and    object_id_one = dotlrn_member_rels_approved.user_id) as portrait_p, 0 as bio_p
             from acs_users_all,
                  dotlrn_member_rels_approved
             where dotlrn_member_rels_approved.community_id = :community_id