Index: openacs-4/packages/forums/lib/message/threads-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/message/Attic/threads-chunk-oracle.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/forums/lib/message/threads-chunk-oracle.xql	9 Nov 2008 23:29:26 -0000	1.6
+++ openacs-4/packages/forums/lib/message/threads-chunk-oracle.xql	22 Nov 2017 14:02:04 -0000	1.7
@@ -38,33 +38,4 @@
         </querytext>
     </fullquery>
 
-    <partialquery name="orderby_user_name_desc">
-        <querytext>
-      user_name desc
-        </querytext>
-    </partialquery>
-    <partialquery name="orderby_user_name_asc">
-        <querytext>
-      user_name asc
-        </querytext>
-    </partialquery>
-
-    <partialquery name="unread_query">
-        <querytext>
-	case when fi.reading_date is null then 't' else 'f' end as unread_p
-        </querytext>
-    </partialquery>
-
-    <partialquery name="unread_join">
-        <querytext>
-	left join forums_reading_info fi on fm.message_id=fi.root_message_id and fi.user_id = :user_id
-        </querytext>
-    </partialquery>
-
-    <partialquery name="new_query">
-        <querytext>
-	case when fm.last_child_post > sysdate-1 then 't' else 'f' end as new_p
-        </querytext>
-    </partialquery>
-
 </queryset>
Index: openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/message/Attic/threads-chunk-postgresql.xql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	15 Jun 2007 18:58:54 -0000	1.7
+++ openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	22 Nov 2017 14:02:04 -0000	1.8
@@ -38,36 +38,4 @@
         </querytext>
     </fullquery>
 
-    <partialquery name="orderby_user_name_desc">
-        <querytext>
-      lower(person__name(fm.last_poster)) desc
-        </querytext>
-    </partialquery>
-    <partialquery name="orderby_user_name_asc">
-        <querytext>
-      lower(person__name(fm.last_poster)) asc
-        </querytext>
-    </partialquery>
-
-    <partialquery name="unread_query">
-        <querytext>
-	case when fi.reading_date is null then 't' else 'f' end as unread_p
-        </querytext>
-    </partialquery>
-
-    <partialquery name="unread_join">
-        <querytext>
-	left join forums_reading_info fi on fm.message_id=fi.root_message_id and fi.user_id = :user_id
-        </querytext>
-    </partialquery>
-
-    <partialquery name="new_query">
-        <querytext>
-	case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as new_p
-        </querytext>
-    </partialquery>
-
-
-
-
 </queryset>
Index: openacs-4/packages/forums/lib/message/threads-chunk.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/message/threads-chunk.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/lib/message/threads-chunk.xql	22 Nov 2017 14:02:04 -0000	1.2
@@ -0,0 +1,34 @@
+<?xml version="1.0"?>
+<queryset>
+
+  <partialquery name="orderby_user_name_desc">
+    <querytext>
+      user_name desc
+    </querytext>
+  </partialquery>
+
+  <partialquery name="orderby_user_name_asc">
+    <querytext>
+      user_name asc
+    </querytext>
+  </partialquery>
+
+  <partialquery name="unread_query">
+    <querytext>
+      case when fi.reading_date is null then 't' else 'f' end as unread_p
+    </querytext>
+  </partialquery>
+
+  <partialquery name="unread_join">
+    <querytext>
+      left join forums_reading_info fi on fm.message_id=fi.root_message_id and fi.user_id = :user_id
+    </querytext>
+  </partialquery>
+
+  <partialquery name="new_query">
+    <querytext>
+      case when fm.last_child_post > current_timestamp - interval '1' day then 't' else 'f' end as new_p
+    </querytext>
+  </partialquery>
+
+</queryset>