SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(inc) cnt from pmswdb.tb_errhistory a where 1=1 and epname like concat('%', #{epname}, '%') and errmsg like concat('%', #{errmsg}, '%') and occurdate between concat(#{startDate}, ' 00:00:00') and concat(#{endDate}, ' 23:59:59') select * from pmswdb.tb_errhistory a where 1=1 and epname like concat('%', #{epname}, '%') and errmsg like concat('%', #{errmsg}, '%') and occurdate between concat(#{startDate}, ' 00:00:00') and concat(#{endDate}, ' 23:59:59') order by inc desc