Index: openacs-4/packages/categories/www/categories-browse.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/www/categories-browse.xql,v
diff -u -r1.4 -r1.4.2.1
--- openacs-4/packages/categories/www/categories-browse.xql	7 Aug 2017 23:48:05 -0000	1.4
+++ openacs-4/packages/categories/www/categories-browse.xql	10 Mar 2021 13:16:15 -0000	1.4.2.1
@@ -2,44 +2,13 @@
 
 <queryset>
 
-  <fullquery name="insert_tmp_category_trees">
-    <querytext>
-      insert into category_temp
-      values (:tree_id)
-    </querytext>
-  </fullquery>
-
-  <fullquery name="delete_tmp_category_trees">
-    <querytext>
-      delete from category_temp
-    </querytext>
-  </fullquery>
-
-  <partialquery name="other_letter">
-    <querytext>
-      and (upper(n.object_name) < 'A' or upper(n.object_name) > 'Z')
-    </querytext>
-  </partialquery>
-
-  <partialquery name="regular_letter">
-    <querytext>
-      and upper(n.object_name) like :bind_letter
-    </querytext>
-  </partialquery>
-
-  <partialquery name="package_objects">
-    <querytext>
-      and n.package_id = :package_id
-    </querytext>
-  </partialquery>
-
   <partialquery name="include_subtree_and">
     <querytext>
       select v.object_id
       from (select distinct m.object_id, c.category_id
             from category_object_map m, categories c,
-                 categories c_sub, category_temp t
-            where c.category_id = t.category_id
+                 categories c_sub
+            where c.category_id in $category_clause
             and m.category_id = c_sub.category_id
             and c_sub.tree_id = c.tree_id
             and c_sub.left_ind >= c.left_ind
@@ -51,8 +20,8 @@
   <partialquery name="exact_categorization_and">
     <querytext>
       select m.object_id
-      from category_object_map m, category_temp t
-      where m.category_id = t.category_id
+      from category_object_map m
+      where m.category_id in $category_clause
       group by m.object_id having count(*) = :category_ids_length
     </querytext>
   </partialquery>
@@ -61,8 +30,8 @@
     <querytext>
       select distinct m.object_id
       from category_object_map m, categories c,
-           categories c_sub, category_temp t
-      where c.category_id = t.category_id
+           categories c_sub
+      where c.category_id in $category_clause
       and m.category_id = c_sub.category_id
       and c_sub.tree_id = c.tree_id
       and c_sub.left_ind >= c.left_ind
@@ -73,16 +42,9 @@
   <partialquery name="exact_categorization_or">
     <querytext>
       select distinct m.object_id
-      from category_object_map m, category_temp t
-      where m.category_id = t.category_id
+      from category_object_map m
+      where m.category_id in $category_clause
     </querytext>
   </partialquery>
 
-  <fullquery name="insert_tmp_categories">
-    <querytext>
-      insert into category_temp
-      values (:category_id)
-    </querytext>
-  </fullquery>
-
 </queryset>