Index: openacs-4/packages/dotlrn/www/admin/clubs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/Attic/clubs.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/dotlrn/www/admin/clubs.xql	8 Apr 2002 13:26:16 -0000	1.3
+++ openacs-4/packages/dotlrn/www/admin/clubs.xql	22 May 2002 18:41:23 -0000	1.4
@@ -4,7 +4,10 @@
 
     <fullquery name="select_clubs">
         <querytext>
-            select dotlrn_clubs_full.*
+            select dotlrn_clubs_full.*,
+                   (select count(*)
+                    from dotlrn_member_rels_approved
+                    where dotlrn_member_rels_approved.community_id = dotlrn_clubs_full.club_id) as n_members
             from dotlrn_clubs_full
             order by dotlrn_clubs_full.pretty_name,
                      dotlrn_clubs_full.description