ID_, NAME_, ROAD_CODE_, ROAD_ID_, CATEGORY_, TYPE_, POINT_LEVEL, INSPECTION_CYCLE_, CONTENT_, PEG_, PEG_ADD_, PEG_VAL_, DIRECTION_, DIRECTION_VALUE_, LNG_, LAT_, ORG_ID_, ORG_FULL_ID_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_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 bp.* FROM biz_inspection_plan p JOIN biz_inspection_plan_details pd ON p.id_ = pd.PLAN_ID_ JOIN biz_base_patrol bp ON pd.PATROL_ID_ = bp.ID_ JOIN biz_inspection_task t ON p.ID_ = t.PLAN_ID_ WHERE t.id_ = #{taskId} AND bp.IS_DELE_ = '0' AND t.IS_DELE_ = '0' AND NOT EXISTS ( SELECT 1 FROM biz_inspection_result_detail rd WHERE rd.TASK_ID_ = t.id_ AND rd.PATROL_ID_ = bp.id_ AND rd.IS_DELE_ = '0')