select *,pm.PROJECT_NAME_ pName from biz_warranty bw left join biz_project_management pm on bw.PROJECT_ID_ = pm.ID_ ${ew.customSqlSegment} where bw.IS_DELE_ = '0' and pm.IS_DELE_ = '0' and pm.VALID_FLAG_ = 1 and bw.ID_ = #{id,jdbcType=VARCHAR}