select node_id from site_nodes sn, cr_folders f where f.folder_id = :item_id and sn.object_id = f.package_id select count(1) from cr_items where parent_id = -400 and name = (select name from cr_items where item_id = :item_id) update cr_items set name = 'Copy of ' || name where item_id = :item_id update cr_items set parent_id = -400, live_revision = NULL where item_id = :item_id