Index: openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql,v
diff -u -N -r1.1 -r1.1.2.1
--- openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql	17 Dec 2003 15:45:29 -0000	1.1
+++ openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql	23 Dec 2004 02:12:53 -0000	1.1.2.1
@@ -6,10 +6,7 @@
     <fullquery name="select_forums">
         <querytext>
             select forums_forums_enabled.*,
-                   (select count(*)
-                    from forums_messages_approved
-                    where forums_messages_approved.forum_id = forums_forums_enabled.forum_id
-                    and parent_id is null) as n_threads,
+                   approved_thread_count as n_threads,
                    to_char(last_post, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi,
                    case when last_post > (sysdate - 1) then 't' else 'f' end as new_p
             from forums_forums_enabled