postgresql7.1
select title
from cr_revisions
where item_id = :item_id
and revision_id = content_item__get_live_revision(:item_id)
select content_item__unset_live_revision(:item_id);
update acs_objects
set last_modified = current_timestamp,
modifying_user = :user_id,
modifying_ip = :peeraddr
where object_id = :item_id