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 -N -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 @@ - - - insert into category_temp - values (:tree_id) - - - - - - delete from category_temp - - - - - - and (upper(n.object_name) < 'A' or upper(n.object_name) > 'Z') - - - - - - and upper(n.object_name) like :bind_letter - - - - - - and n.package_id = :package_id - - - 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 @@ 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 @@ -61,8 +30,8 @@ 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 @@ 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 - - - insert into category_temp - values (:category_id) - - -