select item_id from cr_revisions where revision_id=:object_id select package_id from cr_news where news_id=:object_id select max(o.last_modified) from acs_objects o, cr_news n where n.package_id=:package_id and o.object_id=n.news_id