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 i.parent_id = (select parent_id from cr_items where item_id = :old_album_id) and acs_permission.permission_p(i.item_id, :user_id, 'read') = 't' and i.content_type = 'pa_album' and i.item_id != :old_album_id