postgresql7.1 select 1 select content from cr_revisions where revision_id = :revision_id select content_item__get_id(:url, :content_root, 'f') as item_id select content_type from cr_items where item_id=:item_id select item_id, content_type from cr_items where item_id = :item_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 select content_template__get_path(content_item__get_template(:item_id, :context),:template_root) as template_url from dual