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.4 -r1.5
--- openacs-4/packages/dotlrn/www/admin/clubs.xql	22 May 2002 18:41:23 -0000	1.4
+++ openacs-4/packages/dotlrn/www/admin/clubs.xql	13 Jan 2005 13:57:21 -0000	1.5
@@ -9,9 +9,21 @@
                     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
+	    where 1 = 1
+	    [template::list::page_where_clause -and -name "clubs" -key "dotlrn_clubs_full.club_id"]
+	    [template::list::orderby_clause -orderby -name "clubs"]
         </querytext>
     </fullquery>
 
+    <fullquery name="clubs_pagination">
+        <querytext>
+            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
+            [template::list::orderby_clause -orderby -name "clubs"]
+        </querytext>
+    </fullquery>
+
 </queryset>