SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(k.seq) as count from t_kesco_data k, t_plant p where k.plantSeq = p.seq and sendStatus = #{sendStatus} and k.inputDate >= #{str1} and k.inputDate <= #{str2} and k.inputHour = #{inputHour} and p.name like concat('%', #{plantName}, '%') and p.seq = #{plantSeq} select p.name as plantName, k.* from t_kesco_data k, t_plant p where k.plantSeq = p.seq and sendStatus = #{sendStatus} and k.inputDate >= #{str1} and k.inputDate <= #{str2} and k.inputHour = #{inputHour} and p.name like concat('%', #{plantName}, '%') and p.seq = #{plantSeq} order by k.inputDate desc, k.inputHour desc, k.plantSeq asc select * from t_timetable_kesco k where k.inputDate = #{inputDate} order by k.inputDate desc, k.inputHour desc