Index: openacs-4/packages/dotlrn/www/members-chunk.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/members-chunk.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/dotlrn/www/members-chunk.tcl	22 Mar 2002 22:23:54 -0000	1.8
+++ openacs-4/packages/dotlrn/www/members-chunk.tcl	22 Mar 2002 22:46:58 -0000	1.9
@@ -49,8 +49,7 @@
            dotlrn_member_rels_full.role
     from dotlrn_users,
          dotlrn_member_rels_full
-    where dotlrn_users.user_id = :user_id
-    and dotlrn_users.user_id = dotlrn_member_rels_full.user_id
+    where dotlrn_users.user_id = dotlrn_member_rels_full.user_id
     and dotlrn_member_rels_full.community_id = :community_id
     and dotlrn_member_rels_full.member_state = 'needs approval'
 }