Index: openacs-4/packages/lars-blogger/www/admin/recently-published-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/admin/Attic/recently-published-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/lars-blogger/www/admin/recently-published-postgresql.xql 19 Aug 2002 21:52:59 -0000 1.1 +++ openacs-4/packages/lars-blogger/www/admin/recently-published-postgresql.xql 14 Sep 2002 16:40:35 -0000 1.2 @@ -8,12 +8,12 @@ select entry_id, to_char(entry_date, 'YYYY-MM-DD') as entry_date_pretty, title, - content, - '' as edit_url + content from pinds_blog_entries where package_id = :package_id and posted_date > current_timestamp - interval '14 days' and draft_p = 'f' + and deleted_p = 'f' order by entry_date desc, posted_date desc