oracle8.1.6
select
[ad_decode $storage_type file "'[cr_fs_path]' || filename" content] as content
from
cr_revisions
where
revision_id = $revision_id
select
item_id, mime_type, content_revision.is_live( revision_id ) is_live
from
cr_revisions
where
revision_id = :revision_id