postgresql7.1
select 0 as tree_level, '' as name , 'Home' as title
UNION
select t.tree_level, i.name, content_item.get_title(t.context_id) as title
from (select o2.context_id, tree_level(o2.tree_sortkey) as tree_level
from (select * from acs_objects where object_id = :item_id) o1, acs_objects o2
where context_id <> content_item__get_root_folder()
and o1.tree_sortkey between o2.tree_sortkey and tree_right(o2.tree_sortkey)) t,
cr_items i
where i.item_id = t.context_id
order by tree_level
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