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('%', #{map.epname}, '%') and errmsg like concat('%', #{map.errmsg}, '%') and occurdate between #{map.startDate} and #{map.endDate} select * from pmswdb.tb_errhistory a where 1=1 and epname like concat('%', #{map.epname}, '%') and errmsg like concat('%', #{map.errmsg}, '%') and occurdate between #{map.startDate} and #{map.endDate} order by inc desc