postgresql7.1
select content_symlink__resolve(:template_id)
select content_item__get_path(:template_id, :root_id)
select
content_item__get_title(item_id, 'f') as title, item_id, use_context
from
cr_item_template_map
where
template_id = :template_id
order by
use_context