activityIsrId, activityId, `source`, isrType, isrCount, content, isrDate, policeOrgCode, createOn select from sp_activity_isr where activityIsrId = #{activityIsrId,jdbcType=BIGINT} select isrType, isrDate from sp_activity_isr select from sp_activity_isr t and isrType=#{isrType,jdbcType=VARCHAR} and isrDate>=concat(#{isrStartDate},' 00:00:00') AND ( t.source like CONCAT('%', TRIM(#{keywords}), '%') OR t.content like CONCAT('%', TRIM(#{keywords}), '%') OR t.policeOrgCode= TRIM(#{keywords}) OR t.activityId= TRIM(#{keywords}) ) and activityId=(select id from sp_activity s where s.activityNo=#{activityNo})