Index: openacs-4/packages/news/tcl/news-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news/tcl/news-procs-oracle.xql,v diff -u -r1.8.2.1 -r1.8.2.2 --- openacs-4/packages/news/tcl/news-procs-oracle.xql 5 Oct 2021 10:19:17 -0000 1.8.2.1 +++ openacs-4/packages/news/tcl/news-procs-oracle.xql 5 Oct 2021 10:21:59 -0000 1.8.2.2 @@ -37,29 +37,4 @@ - - - - select * from ( - select cn.*, - ci.item_id, - cr.content, - cr.title, - cr.mime_type, - cr.description, - to_char(o.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified - from cr_news cn, - cr_revisions cr, - cr_items ci, - acs_objects o - where cn.package_id=:summary_context_id - and cr.revision_id=cn.news_id - and cn.news_id=o.object_id - and cr.item_id=ci.item_id - and cr.revision_id=ci.live_revision - order by o.last_modified desc - ) where rownum <= $limit - - -