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