select * from biz_project_establishment bpe left join biz_project_management pm on bpe.PROJECT_ID_ = pm.ID_ ${ew.customSqlSegment} where bpe.IS_DELE_ = '0' and pm.IS_DELE_ = '0' and pm.VALID_FLAG_ = 1 and bpe.ID_ = #{id,jdbcType=VARCHAR} SELECT b.PROJECT_TYPE_ type, SUM( a.CONSTRUCTION_LENGTH_ ) lengthTotal , SUM( a.CONSTRUCTION_WIDTH_ ) widthTotal , SUM( a.CONSTRUCTION_HEIGHT_ ) areaTotal FROM biz_project_establishment a LEFT JOIN biz_project_management b ON a.PROJECT_ID_ = b.ID_ WHERE a.IS_DELE_ = 0 AND b.PROJECT_TYPE_ IS NOT NULL AND b.PROJECT_TYPE_ != '' AND a.PROJECT_ID_ = #{statisticsVo.projectId} AND b.PROJECT_TYPE_ = #{statisticsVo.type} AND a.ESTABLISHMENT_DATE_ >== #{statisticsVo.startTime} AND a.ESTABLISHMENT_DATE_ <== #{statisticsVo.endTime} GROUP BY b.PROJECT_TYPE_ ORDER BY b.PROJECT_TYPE_ SELECT ESTABLISHMENT_INVESTMENT_AMOUNT_ FROM biz_project_establishment WHERE PROJECT_ID_ = ${id} AND IS_DELE_ = 0 ORDER BY CREATE_TIME_ ASC LIMIT 1;