Index: openacs-4/packages/dotlrn/www/members-chunk-table-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/members-chunk-table-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/dotlrn/www/members-chunk-table-postgresql.xql	4 Dec 2002 09:51:04 -0000	1.3
+++ openacs-4/packages/dotlrn/www/members-chunk-table-postgresql.xql	17 May 2004 15:15:02 -0000	1.4
@@ -9,13 +9,15 @@
                    dotlrn_member_rels_approved.rel_type,
                    dotlrn_member_rels_approved.role,
                    dotlrn_member_rels_approved.user_id,
-                   registered_users.first_names,
-                   registered_users.last_name,
-                   registered_users.email
-            from registered_users,
+                   acs_users_all.first_names,
+                   acs_users_all.last_name,
+                   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
+            from acs_users_all,
                  dotlrn_member_rels_approved
             where dotlrn_member_rels_approved.community_id = :community_id
-            and dotlrn_member_rels_approved.user_id = registered_users.user_id
+            and dotlrn_member_rels_approved.user_id = acs_users_all.user_id
             order by (
                 CASE 
                     WHEN role = 'instructor'