oracle8.1.6 select r.title as name, i.item_id from cr_items i, cr_revisions r where i.live_revision = r.revision_id and acs_permission.permission_p(i.item_id, :user_id, 'pa_create_photo') = 't' and i.content_type = 'pa_album' and i.item_id != :old_album_id connect by prior i.item_id = i.parent_id start with i.item_id = :root_folder_id