select distinct r.item_id, n.package_id from cr_revisions r, cr_news n where (r.revision_id=:object_id or r.item_id = :object_id) and r.revision_id = n.news_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 live_revision AS image_id FROM cr_items WHERE content_type = 'image' AND parent_id = :item_id