Index: openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql 17 Oct 2003 00:39:56 -0000 1.3 +++ openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql 11 Dec 2003 21:40:15 -0000 1.4 @@ -19,7 +19,7 @@ from apm_packages p left outer join pinds_blog_entries e on (e.package_id = p.package_id) join acs_objects o on (o.object_id = e.entry_id) join - all_users u on (u.user_id = o.creation_user) + acs_users_all u on (u.user_id = o.creation_user) where p.package_id in ([join $list_of_package_ids ", "]) and e.entry_date > current_timestamp - interval '30 days' and e.draft_p = 'f'