limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(a.activityCarId,'') AS activityCarId ,a.carNo ,a.depart ,a.arrive ,a.startDate ,DATE_FORMAT(a.createOn,'%Y-%m-%d %H:%i:%s') AS createTime ,b.vehicleNo ,b.carModel ,b.carColor ,b.brandCN ,b.brandEN ,b.carType ,b.carUse ,b.carCharge ,b.carDriver , sex, idCardNo, avatar, a.fullName, age, education, nation, marry, birthplace, a.region, a.address, a.name, fileLocation, politics, carDanger FROM sp_activity_car a INNER JOIN base_car b ON a.carId = b.carId LEFT JOIN sp_activity c ON a.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( a.carNo like CONCAT('%', #{keywords}, '%') OR b.vehicleNo like CONCAT('%', #{keywords}, '%') OR b.carModel like CONCAT('%', #{keywords}, '%') OR b.carColor like CONCAT('%', #{keywords}, '%') OR b.brandCN like CONCAT('%', #{keywords}, '%') OR b.brandEN like CONCAT('%', #{keywords}, '%') ) AND b.carType = #{carType} AND a.createOn >= CONCAT(#{startDate}," 00:00:00") AND CONCAT(#{endDate}," 23:59:59") >= a.createOn limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(t.activityCarTrackId,'') AS activityCarTrackId ,a.carNo ,b.vehicleNo ,t.longitude ,t.latitude ,t.createOn FROM sp_activity_car_track t LEFT JOIN sp_activity_car a ON t.activityCarId = a.activityCarId INNER JOIN base_car b ON a.carId = b.carId LEFT JOIN sp_activity c ON a.activityId = c.id WHERE 1 = 1 AND c.activityNo = #{activityNo} AND a.activityCarId = #{activityCarId} AND ( a.carNo like CONCAT('%', #{keywords}, '%') OR b.vehicleNo like CONCAT('%', #{keywords}, '%') OR t.activityCarTrackId like CONCAT('%', #{keywords}, '%') ) AND t.createOn >= CONCAT(#{startDate}," 00:00:00") AND CONCAT(#{endDate}," 23:59:59") >= t.createOn limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT a.carNo ,a.vehicleNo ,a.carType ,a.areaCode ,a.policeAreaCode ,a.policeOrg FROM base_police_car a LEFT JOIN sp_activity_police_car b ON a.policeCarId = b.policeCarId LEFT JOIN sp_activity c ON b.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( a.carNo like CONCAT('%', #{keywords}, '%') OR a.vehicleNo like CONCAT('%', #{keywords}, '%') OR a.areaCode like CONCAT('%', #{keywords}, '%') OR a.policeAreaCode like CONCAT('%', #{keywords}, '%') OR a.policeOrg like CONCAT('%', #{keywords}, '%') ) AND a.carType = #{carType} AND a.createOn >= CONCAT(#{startDate}," 00:00:00") AND CONCAT(#{endDate}," 23:59:59") >= a.createOn limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(a.activityParkId,'') AS activityParkId ,a.parkTotal ,a.bookTotal ,b.parkNo ,b.parkName ,b.parkType ,b.packAddress ,b.entryCount ,b.exitCount ,b.longitude ,b.latitude ,b.manageOrg ,b.manageName ,b.manageMobile ,b.source ,b.dataStatus ,b.createOn ,b.total FROM sp_activity_park a LEFT JOIN base_park b ON a.parkId = b.parkId LEFT JOIN sp_activity c ON a.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( b.parkNo like CONCAT('%', #{keywords}, '%') OR b.parkName like CONCAT('%', #{keywords}, '%') OR b.packAddress like CONCAT('%', #{keywords}, '%') OR b.manageOrg like CONCAT('%', #{keywords}, '%') OR b.total like CONCAT('%', #{keywords}, '%') ) AND b.parkType = #{parkType} limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(a.activityTrafficId,'') AS activityTrafficId ,a.roadNo ,a.roadName ,a.sectionNo ,a.sectionName ,a.direction ,a.congestion ,DATE_FORMAT(a.createOn,'%Y-%m-%d %H:%i:%s') AS createOn FROM sp_activity_traffic a LEFT JOIN sp_activity c ON a.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( a.roadNo like CONCAT('%', #{keywords}, '%') OR a.roadName like CONCAT('%', #{keywords}, '%') OR a.sectionNo like CONCAT('%', #{keywords}, '%') OR a.sectionName like CONCAT('%', #{keywords}, '%') OR a.direction like CONCAT('%', #{keywords}, '%') OR a.congestion like CONCAT('%', #{keywords}, '%') ) AND a.createOn >= CONCAT(#{startDate}," 00:00:00") AND CONCAT(#{endDate}," 23:59:59") >= a.createOn