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.5 -r1.6
--- openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql	27 Apr 2009 16:32:22 -0000	1.5
+++ openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql	23 Nov 2017 12:33:11 -0000	1.6
@@ -16,14 +16,4 @@
         </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>
Index: openacs-4/packages/forums/lib/forums/forums-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/forums/forums-chunk-postgresql.xql,v
diff -u -N -r1.5 -r1.6
--- openacs-4/packages/forums/lib/forums/forums-chunk-postgresql.xql	27 Apr 2009 16:32:22 -0000	1.5
+++ openacs-4/packages/forums/lib/forums/forums-chunk-postgresql.xql	23 Nov 2017 12:33:11 -0000	1.6
@@ -16,15 +16,4 @@
         </querytext>
     </fullquery>
 
-    <partialquery name="unread_or_new_query">
-        <querytext>
-	approved_thread_count-coalesce((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>
Index: openacs-4/packages/forums/lib/forums/forums-chunk.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/forums/forums-chunk.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/lib/forums/forums-chunk.xql	23 Nov 2017 12:33:11 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+<queryset>
+
+    <partialquery name="unread_or_new_query">
+        <querytext>
+	  approved_thread_count - coalesce(
+            (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>
Index: openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql	4 Jan 2007 09:08:15 -0000	1.8
+++ openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql	23 Nov 2017 12:38:07 -0000	1.9
@@ -2,27 +2,6 @@
 <queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-  <fullquery name="workflow::get_not_cached.workflow_info">
-    <querytext>
-      select w.workflow_id,
-             w.short_name,
-             w.pretty_name,
-             w.object_id,
-             w.package_key,
-             w.object_type,
-             w.description,
-             w.description_mime_type,
-             a.short_name as initial_action,
-             a.action_id as initial_action_id
-      from   workflows w,
-             workflow_actions a
-      where  w.workflow_id = :workflow_id
-        and  w.workflow_id = a.workflow_id (+)
-        and  a.parent_action_id is null
-	and  a.trigger_type(+) = 'init'
-    </querytext>
-  </fullquery>
-
   <fullquery name="workflow::edit.do_insert">
     <querytext>
         begin
@@ -47,13 +26,5 @@
         end;
     </querytext>
   </fullquery>
- 
-  <fullquery name="workflow::callback_insert.select_sort_order">
-    <querytext>
-        select nvl(max(sort_order),0) + 1
-        from   workflow_callbacks
-        where  workflow_id = :workflow_id
-    </querytext>
-  </fullquery>
-
+  
 </queryset>
Index: openacs-4/packages/workflow/tcl/workflow-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs-postgresql.xql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/workflow/tcl/workflow-procs-postgresql.xql	23 Jan 2004 11:02:27 -0000	1.8
+++ openacs-4/packages/workflow/tcl/workflow-procs-postgresql.xql	23 Nov 2017 12:38:07 -0000	1.9
@@ -2,27 +2,6 @@
 <queryset>
   <rdbms><type>postgresql</type><version>7.2</version></rdbms>
 
-  <fullquery name="workflow::get_not_cached.workflow_info">
-    <querytext>
-      select w.workflow_id,
-             w.short_name,
-             w.pretty_name,
-             w.object_id,
-             w.package_key,
-             w.object_type,
-             w.description,
-             w.description_mime_type,
-             a.short_name as initial_action,
-             a.action_id as initial_action_id
-      from   workflows w left outer join
-             workflow_actions a on (a.workflow_id = w.workflow_id
-                                and a.parent_action_id is null
-                                and a.trigger_type = 'init')
-      where  w.workflow_id = :workflow_id
-    </querytext>
-  </fullquery>
-
-
   <fullquery name="workflow::edit.do_insert">
     <querytext>
         select workflow__new (
@@ -44,12 +23,4 @@
     </querytext>
   </fullquery>
   
-  <fullquery name="workflow::callback_insert.select_sort_order">
-    <querytext>
-        select coalesce(max(sort_order),0) + 1
-        from   workflow_callbacks
-        where  workflow_id = :workflow_id
-    </querytext>
-  </fullquery>
-
  </queryset>
Index: openacs-4/packages/workflow/tcl/workflow-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs.xql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/workflow/tcl/workflow-procs.xql	29 Oct 2003 10:47:12 -0000	1.7
+++ openacs-4/packages/workflow/tcl/workflow-procs.xql	23 Nov 2017 12:38:07 -0000	1.8
@@ -1,6 +1,34 @@
 <?xml version="1.0"?>
 <queryset>
 
+  <fullquery name="workflow::get_not_cached.workflow_info">
+    <querytext>
+      select w.workflow_id,
+             w.short_name,
+             w.pretty_name,
+             w.object_id,
+             w.package_key,
+             w.object_type,
+             w.description,
+             w.description_mime_type,
+             a.short_name as initial_action,
+             a.action_id as initial_action_id
+      from   workflows w left outer join
+             workflow_actions a on (a.workflow_id = w.workflow_id
+                                and a.parent_action_id is null
+                                and a.trigger_type = 'init')
+      where  w.workflow_id = :workflow_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="workflow::callback_insert.select_sort_order">
+    <querytext>
+        select coalesce(max(sort_order),0) + 1
+        from   workflow_callbacks
+        where  workflow_id = :workflow_id
+    </querytext>
+  </fullquery>  
+  
   <fullquery name="workflow::get_id_not_cached.select_workflow_id_by_object_id">
     <querytext>
       select workflow_id