postgresql7.1 select title, description, story from pa_albumsx where object_id = content_item__get_live_revision(:album_id) select repeat('   ',(tree_level(ci.tree_sortkey) - 1) * 18) || content_folder__get_label(ci.item_id) as padded_name, ci.item_id as folder_id from cr_items ci, cr_items i2 where ci.content_type = 'content_folder' -- do not include the albums current folder in move to list and ci.item_id <> :old_folder_id and acs_permission__permission_p(ci.item_id, :user_id, 'pa_create_album') and ci.tree_sortkey between i2.tree_sortkey and tree_right(i2.tree_sortkey) and i2.item_id = :root_folder_id order by ci.tree_sortkey select content_item__move ( :album_id, -- item_id :new_folder_id -- target_folder_id )