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
select cn.*,
ci.item_id,
cr.content,
cr.title,
cr.mime_type,
cr.description,
to_char(o.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified
from cr_news cn,
cr_revisions cr,
cr_items ci,
acs_objects o
where cn.package_id=:summary_context_id
and cr.revision_id=cn.news_id
and cn.news_id=o.object_id
and cr.item_id=ci.item_id
and cr.revision_id=ci.live_revision
order by o.last_modified desc
limit $limit