ID_, TASK_ID_, TASK_VERSON_ID, TYPE_, FIELD_RELATION_STATUS_, INDEX_TYPE_, INDEX_ID_, CODE_, NAME_, PARENT_ID_, WEIGHT_, LEVEL_, FULL_ID_, FULL_NAME_, HAS_CHILDREN_, UPDATE_RESULT_, SN_, BACKGROUND_, FONT_COLOR_, FONT_SIZE_, FONT_WETIGHT_, FONT_STYLE_, INDEX_ICON_, INDEX_MEMO_, INDEX_ANNOTATION_, INDEX_URL_, RELATION_CONTENT_, CONTENT_ select t.*,t1.version_name_ from biz_algorithm_reason t left join BIZ_ALGORITHM_VERSION t1 on t.TASK_VERSON_ID=t1.ID_ where IS_DELE_=0 and TASK_VERSON_ID in (select id_ from BIZ_ALGORITHM_VERSION t right join ( select max(version_code_) version_code_ from BIZ_ALGORITHM_VERSION where task_id=#{taskId} and IS_DELE_=0 ) t1 on t.version_code_=t1.version_code_) and task_id_=#{taskId} and TASK_VERSON_ID =#{versionId}