Index: openacs-4/packages/forums/www/forum-view-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/forum-view-postgresql.xql,v
diff -u -r1.4 -r1.4.2.1
--- openacs-4/packages/forums/www/forum-view-postgresql.xql	24 Jun 2002 21:40:16 -0000	1.4
+++ openacs-4/packages/forums/www/forum-view-postgresql.xql	22 Nov 2002 18:38:32 -0000	1.4.2.1
@@ -14,13 +14,11 @@
                     from forums_messages_approved fm1
                     where fm1.forum_id = :forum_id
                     and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages,
-                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified,
-                   case when acs_objects.last_modified > (now() - 1) then 't' else 'f' end as new_p                   
-            from forums_messages_approved fm,
-                 acs_objects
+                   to_char(fm.last_child_post, 'Mon DD YYYY HH24:MI:SS') as last_child_post,
+                   case when fm.last_child_post > (now() - 1) then 't' else 'f' end as new_p                   
+            from forums_messages_approved fm
             where fm.forum_id = :forum_id
             and fm.parent_id is null
-            and fm.message_id = acs_objects.object_id
             order by fm.posting_date desc
         </querytext>
     </fullquery>
@@ -37,13 +35,11 @@
                     from forums_messages fm1
                     where fm1.forum_id = :forum_id
                     and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages,
-                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified,
-                   case when acs_objects.last_modified > (now() - 1) then 't' else 'f' end as new_p                   
-            from forums_messages fm,
-                 acs_objects
+                   to_char(fm.last_child_post, 'Mon DD YYYY HH24:MI:SS') as last_child_post,
+                   case when fm.last_child_post > (now() - 1) then 't' else 'f' end as new_p                   
+            from forums_messages_approved fm
             where fm.forum_id = :forum_id
             and fm.parent_id is null
-            and fm.message_id = acs_objects.object_id
             order by fm.posting_date desc
         </querytext>
     </fullquery>