insert into dav_site_node_folder_map (folder_id, node_id, enabled_p) values (:folder_id, :node_id, :enabled_p) delete from dav_site_node_folder_map where folder_id=:folder_id and node_id=:node_id select folder_id from dav_site_node_folder_map where node_id=:node_id and enabled_p = 't' select content_type from cr_items where item_id=:item_id update cr_items set live_revision=:revision_id where item_id=(select item_id from cr_revisions where revision_id=:revision_id) select count(*) from dav_site_node_folder_map where folder_id=:move_folder_id update cr_items set live_revision=latest_revision where item_id=:item_id