Index: openacs-4/packages/forums/www/moderate/forum-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/moderate/Attic/forum-oracle.xql,v
diff -u -r1.1 -r1.1.6.1
--- openacs-4/packages/forums/www/moderate/forum-oracle.xql	25 Jun 2002 15:38:17 -0000	1.1
+++ openacs-4/packages/forums/www/moderate/forum-oracle.xql	2 Mar 2004 14:49:41 -0000	1.1.6.1
@@ -15,9 +15,10 @@
             where message_id in (select message_id
                                  from forums_messages_pending
                                  where forum_id = :forum_id)
-            or tree_sortkey in (select substr(tree_sortkey, 1, 6)
+            or (tree_sortkey in (select substr(tree_sortkey, 1, 6)
                                 from forums_messages_pending
                                 where forum_id = :forum_id)
+	        and forum_id = :forum_id)
             order by tree_sortkey
         </querytext>
     </fullquery>