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