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.3 -r1.4
--- openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql	4 Jun 2007 12:24:32 -0000	1.3
+++ openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql	15 Jun 2007 11:59:55 -0000	1.4
@@ -8,7 +8,7 @@
             select forums_forums_enabled.*,
                    approved_thread_count as n_threads,
                    to_char(last_post, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi,
-		   $unread_or_new_query
+		   $unread_or_new_query_clause
             from forums_forums_enabled
             where forums_forums_enabled.package_id = :package_id
             and (
@@ -20,4 +20,14 @@
         </querytext>
     </fullquery>
 
+    <partialquery name="unread_or_new_query">
+        <querytext>
+	approved_thread_count-nvl((SELECT forums_reading_info_user.threads_read
+					FROM forums_reading_info_user
+					WHERE forums_reading_info_user.forum_id=forums_forums_enabled.forum_id 
+					AND forums_reading_info_user.user_id=:user_id), 0)
+	as count_unread
+        </querytext>
+    </partialquery>
+
 </queryset>