Index: openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql 7 Aug 2017 23:48:12 -0000 1.5 +++ openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql 22 May 2018 14:32:10 -0000 1.6 @@ -3,26 +3,6 @@ oracle8.1.6 - - - select forums_forums.package_id, - acs_object.name(apm_package.parent_id(forums_forums.package_id)) as parent_name, - (select site_node.url(site_nodes.node_id) - from site_nodes - where site_nodes.object_id = forums_forums.package_id) as url, - forums_forums.forum_id, - forums_forums.name, - $unread_or_new_query - from forums_forums_enabled forums_forums, - acs_objects - where acs_objects.object_id = forums_forums.forum_id and - forums_forums.package_id in ([join $list_of_package_ids ,]) - $private_data_restriction - order by parent_name, - forums_forums.name - - - and exists (