postgresql7.1
select 1
select
content
from
cr_revisions
where
revision_id = :revision_id
select
content_item__get_live_revision(content_item__get_template(:item_id, :context)) as template_id,
content_template__get_path(content_item__get_template(:item_id, :context),:template_root) as template_url
from dual