postgresql
7.2
select content_item__move(
:one_item,
:folder_id
)
select
cf.folder_id, cf.label, tree_level(ci1.tree_sortkey) as level
from cr_folders cf, cr_items ci1, cr_items ci2
where
ci1.tree_sortkey between ci2.tree_sortkey and
tree_right(ci2.tree_sortkey)
and ci2.item_id=:root_folder_id
and ci1.item_id=cf.folder_id
and exists (select 1
from acs_object_party_privilege_map m
where m.object_id = cf.folder_id
and m.party_id = :user_id
and m.privilege = 'write')
order by tree_level(ci1.tree_sortkey), cf.label