activityBuildId, activityId, fullName, chargeName, chargeMobile, itemTotal, unApproveItemTotal, passItemTotal, failItemTotal, uploadDocTotal, addTime,updateTime select from sp_activity_build where activityBuildId = #{activityBuildId,jdbcType=BIGINT} select from sp_activity_build and updateTime>=concat(#{updateTimeStart},' 00:00:00') AND ( fullName like CONCAT('%', TRIM(#{keywords}), '%') OR chargeName like CONCAT('%', TRIM(#{keywords}), '%') OR chargeMobile like CONCAT('%', TRIM(#{keywords}), '%') ) and activityId=(select id from sp_activity s where s.activityNo=#{activityNo})