postgresql7.1 select file_storage__get_root_folder(:package_id); select content_folder__get_label(:folder_id); select count(*) from cr_items where item_id in (select item_id from cr_items where tree_sortkey like (select tree_sortkey || '%' from cr_items where item_id = :item_id) order by tree_sortkey) and acs_permission__permission_p(item_id,:user_id,:privilege) = 'f' select item_id as child_item_id from cr_items where tree_sortkey like (select tree_sortkey || '%' from cr_items where item_id = :item_id) order by tree_sortkey select count(*) from cr_revisions where item_id = :child_item_id and acs_permission__permission_p(revision_id,:user_id,:privilege) = 'f' select content_item__get_title(:item_id); select (case when content_item__get_content_type(i.item_id) = 'content_folder' then '?folder_id=' else 'file?file_id=' end) || i.item_id, content_item__get_title(i.item_id) from cr_items i where item_id not in (select i2.item_id from cr_items i2 where i2.tree_sortkey like (select i3.tree_sortkey || '%' from cr_items i3 where i3.item_id = file_storage__get_root_folder([ad_conn package_id])) order by i2.tree_sortkey) and i.tree_sortkey like (select i4.tree_sortkey || '%' from cr_items i4 where i4.item_id = :start_id) order by i.tree_sortkey, i.level desc