Index: openacs-4/packages/dotlrn/www/admin/term.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/term.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/dotlrn/www/admin/term.xql	13 Jan 2005 13:57:21 -0000	1.8
+++ openacs-4/packages/dotlrn/www/admin/term.xql	8 Aug 2006 21:26:28 -0000	1.9
@@ -13,114 +13,6 @@
         </querytext>
     </fullquery>
 
-    <fullquery name="select_classes">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   (select count(*)
-                    from dotlrn_member_rels_approved
-                    where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
-            from dotlrn_class_instances_full
-	    $keyword_clause
-            and dotlrn_class_instances_full.term_id = :term_id
-	    [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"]
-	    [template::list::orderby_clause -orderby -name "classes"]
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_classes_paginator">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   (select count(*)
-                    from dotlrn_member_rels_approved
-                    where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
-            from dotlrn_class_instances_full
-	    $keyword_clause
-            and dotlrn_class_instances_full.term_id = :term_id
-            [template::list::orderby_clause -orderby -name "classes"]
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_classes_by_department">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   (select count(*)
-                    from dotlrn_member_rels_approved
-                    where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
-            from dotlrn_class_instances_full
-	    $keyword_clause
-            and dotlrn_class_instances_full.term_id = :term_id
-            and dotlrn_class_instances_full.department_key = :department_key
-	    [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"]
-	    [template::list::orderby_clause -orderby -name "classes"]
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_classes_paginator_by_department">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   (select count(*)
-                    from dotlrn_member_rels_approved
-                    where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
-            from dotlrn_class_instances_full
-	    $keyword_clause
-            and dotlrn_class_instances_full.term_id = :term_id
-            and dotlrn_class_instances_full.department_key = :department_key
-            [template::list::orderby_clause -orderby -name "classes"]
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_all_classes">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   (select count(*)
-                    from dotlrn_member_rels_approved
-                    where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
-            from dotlrn_class_instances_full
-	    $keyword_clause
-	    [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"]
-	    [template::list::orderby_clause -orderby -name "classes"]
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_all_classes_paginator">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   (select count(*)
-                    from dotlrn_member_rels_approved
-                    where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
-            from dotlrn_class_instances_full
-       	    $keyword_clause
-            [template::list::orderby_clause -orderby -name "classes"]
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_all_classes_by_department">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   (select count(*)
-                    from dotlrn_member_rels_approved
-                    where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
-            from dotlrn_class_instances_full
-	    $keyword_clause
-            and dotlrn_class_instances_full.department_key = :department_key
-	    [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"]
-	    [template::list::orderby_clause -orderby -name "classes"]
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_all_classes_paginator_by_department">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   (select count(*)
-                    from dotlrn_member_rels_approved
-                    where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
-            from dotlrn_class_instances_full
-	    $keyword_clause
-            and dotlrn_class_instances_full.department_key = :department_key
-            [template::list::orderby_clause -orderby -name "classes"]
-        </querytext>
-    </fullquery>
-
     <partialquery name="select_all_instances_keyword">
       <querytext>
 	  where lower(dotlrn_class_instances_full.pretty_name) like '%'||lower(:keyword)||'%'