postgresql7.1 parent_id in (select children.item_id from cr_items parent, cr_items children where parent.item_id = :folder_id and children.content_type = 'content_folder' and children.tree_sortkey between parent.tree_sortkey and tree_right(parent.tree_sortkey)) select * from ( select o.object_id as item_id, o.title, o.name, o.file_upload_name, o.type, o.content_size, to_char(r.publish_date,'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi, r.description, r.revision_id from fs_objects o, cr_revisions r where $parent_clause and type != 'folder' and $revisions_clause order by last_modified desc ) as v limit :max_items select (max(last_modified)-to_date('1970-01-01','YYYY-MM-DD'))*60*60*24 as last_update from fs_rss_subscrs s, fs_objects f where s.subscr_id = :summary_context_id and f.parent_id = s.folder_id and f.type != 'folder'