Index: openacs-4/packages/news-portlet/www/news-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-portlet/www/news-portlet-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/news-portlet/www/news-portlet-postgresql.xql	8 Aug 2006 21:27:05 -0000	1.4
+++ openacs-4/packages/news-portlet/www/news-portlet-postgresql.xql	7 Aug 2017 23:48:12 -0000	1.5
@@ -10,21 +10,20 @@
                    (select site_node__url(site_nodes.node_id)
                     from site_nodes
                     where site_nodes.object_id = news_items_approved.package_id) as url,
-                   news_items_approved.item_id,
-                   news_items_approved.publish_title,
+                   item_id,
+                   publish_title,
                    to_char(news_items_approved.publish_date, 'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi,
                    item_creator,
                    creation_user
                    $content_column
             from news_items_approved
-            where news_items_approved.publish_date < current_timestamp
-            and (news_items_approved.archive_date >= current_timestamp or news_items_approved.archive_date is null)
-            and news_items_approved.package_id in ([join $list_of_package_ids ", "])
+            where publish_date < current_timestamp
+            and (archive_date >= current_timestamp or archive_date is null)
+            and package_id in ([join $list_of_package_ids ", "])
             order by package_id,
                      parent_name,
-                     news_items_approved.publish_date desc,
-                     news_items_approved.publish_title			
-
+                     publish_date desc,
+                     publish_title
         </querytext>
     </fullquery>