activityGatherId, activityId, gatherNo, gatherName, gatherLevel, description, gatherDate, securityOrgCode, securityOrg, checkCount, interceptCount, returnCount, dangerCount, addTime,updateTime select t2.activityNo,t2.fullName,t2.typeCode,t2.number, activityGatherId, activityId, gatherNo, gatherName, gatherLevel, description, gatherDate, securityOrgCode, securityOrg, checkCount, interceptCount, returnCount, dangerCount,t1.updateTime from sp_activity_gather t1 left join sp_activity t2 on t1.activityId=t2.id where activityGatherId = #{activityGatherId,jdbcType=BIGINT} select from sp_activity_gather and gatherLevel=#{gatherLevel,jdbcType=VARCHAR} and gatherDate>=concat(#{gatherStartDate},' 00:00:00') AND ( gatherName like CONCAT('%', TRIM(#{keywords}), '%') ) and activityId=(select id from sp_activity s where s.activityNo=#{activityNo})