postgresql7.1 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, case when last_modified > (cast(current_timestamp as date)- 1) then 't' else 'f' end as new_p 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 ,]) order by parent_name, forums_forums.name