ID_, RESCUE_ID_, APPRAISE_INFO_, APPRAISE_SCORE_, APPRAISE_TEL_, IS_COMPLAIN_, APPRAISE_TIME_, REVISIT_TIME_, REVISIT_RESULT_, REVISIT_MEMO_, IS_COST_, IS_INVOICE_, IS_SERVICE_, COMPLAIN_VALID_, OTHERS_, CREATE_BY_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ SELECT r.ID_ AS rescueId, 3 AS appraiseScore, 0 AS revisitResult, NOW() AS appraiseTime, 1 AS isCost, 1 AS isInvoice, 1 AS isService, 0 AS isComplain, CAR_USER_TEL_ AS appraiseTel FROM biz_rescue_info r LEFT JOIN ( SELECT RESCUE_ID_, MAX( CREATE_TIME_ ) AS FINISH_TIME_ FROM biz_rescue_handle WHERE RESCUE_NODE_ IN ('11','10') AND IS_DELE_ = '0' GROUP BY RESCUE_ID_ ) h ON r.ID_ = h.RESCUE_ID_ LEFT JOIN biz_rescue_appraise a ON r.id_ = a.RESCUE_ID_ WHERE r.IS_DELE_ = '0' AND a.id_ IS NULL AND DATEDIFF( NOW(), FINISH_TIME_ )>=3