limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(a.activityPersonStaffId,'') AS activityPersonStaffId ,c.activityNo ,a.cardNo ,a.isEntry ,a.entryDate ,a.accreditationDate ,p.fullName ,p.idCardNo ,p.mobile FROM sp_activity_person_staff a INNER JOIN base_person p ON a.personId = p.personId LEFT JOIN sp_activity c ON a.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( p.idCardNo like CONCAT('%', #{keywords}, '%') OR p.fullName like CONCAT('%', #{keywords}, '%') OR p.mobile like CONCAT('%', #{keywords}, '%') ) AND a.isEntry = #{isEntry} AND a.accreditationDate >= CONCAT(#{startDate}," 00:00:00") AND CONCAT(#{endDate}," 23:59:59") >= a.accreditationDate AND a.entryDate >= CONCAT(#{startDate2}," 00:00:00") AND CONCAT(#{endDate2}," 23:59:59") >= a.entryDate limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(a.activityPersonId,'') AS activityPersonId ,c.activityNo ,a.ticketNo ,a.buyTicketDate ,a.entryDate ,a.isEntry ,p.fullName ,p.idCardNo ,p.mobile FROM sp_activity_person a INNER JOIN base_person p ON a.personId = p.personId LEFT JOIN sp_activity c ON a.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( p.idCardNo like CONCAT('%', #{keywords}, '%') OR p.fullName like CONCAT('%', #{keywords}, '%') OR p.mobile like CONCAT('%', #{keywords}, '%') OR a.ticketNo like CONCAT('%', #{keywords}, '%') ) AND a.isEntry = #{isEntry} AND a.buyTicketDate >= CONCAT(#{startDate}," 00:00:00") AND CONCAT(#{endDate}," 23:59:59") >= a.buyTicketDate AND a.entryDate >= CONCAT(#{startDate2}," 00:00:00") AND CONCAT(#{endDate2}," 23:59:59") >= a.entryDate