Index: openacs-4/packages/learning-content/tcl/learning-content-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/learning-content/tcl/learning-content-procs.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/learning-content/tcl/learning-content-procs.xql 5 Mar 2009 21:28:57 -0000 1.1 +++ openacs-4/packages/learning-content/tcl/learning-content-procs.xql 18 Aug 2011 23:18:57 -0000 1.2 @@ -175,7 +175,7 @@ where c.object_id = ci.item_id and ci.parent_id = :wiki_folder_id and ci.content_type not in ('::xowiki::PageTemplate') - and ci.name not in ('es:header_page','es:index','es:indexe') + and ci.name not in ('en:header_page','en:index','en:indexe') and r.revision_id = ci.live_revision and p.page_id = r.revision_id and c.category_id = :cat_id @@ -238,6 +238,22 @@ + + + select com.object_id + from category_object_map com $join_clause + where com.category_id = :category_id $where_clause + + + + + + select com.object_id + from category_object_map com $join_clause + where com.category_id = :category_id $where_clause + + + select count(p.page_id)