//数据订正修改类型
update TwmCustomerOperationLogs set type = 2 WHERE customerCode in (SELECT customerCode from (select customerCode from TwmCustomerOperationLogs where operationContent like '%线索%') as twm)
//订正线索组织
update TwmCustomerOperationLogs tc RIGHT JOIN TwmClew twm on tc.customerCode = twm.clewCode set tc.organizationIds = twm.organizationIds
//订正客户组织
update TwmCustomerOperationLogs tc RIGHT JOIN TwmCustomerRecords twm on tc.customerCode = twm.customerCode set tc.organizationIds = twm.organizationIds