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 k.inputDate >= #{str1} and k.inputDate <= #{str2} and k.inputHour = #{inputHour} and p.name like concat('%', #{plantName}, '%') and p.seq = #{plantSeq} and k.sendStatus = #{sendStatus} select p.name as plantName, k.* from t_kesco_data k, t_plant p where k.plantSeq = p.seq and k.inputDate >= #{str1} and k.inputDate <= #{str2} and k.inputHour = #{inputHour} and p.name like concat('%', #{plantName}, '%') and p.seq = #{plantSeq} and k.sendStatus = #{sendStatus} order by k.inputDate desc, k.inputHour desc, k.plantSeq asc select k.*, d.seq as pmsdataSeq, d.pcsIdx, d.inputDate, d.inputHour, d.chargePower, d.dischargePower, d.pvPower, d.data1, d.data2, d.data3, d.data4, d.data5, d.data6, d.data7, d.data8, d.data9, d.data10, d.data11, d.data12, d.data13, d.data14, d.data15, d.data16, d.data17, d.data18, d.data19, d.data20, d.data21, d.data22, d.data23, d.data24, d.data25, d.data26, d.data27, d.data28, d.data29, d.data30, d.data31, d.data32, d.data33, d.data51, d.data52, d.data53, d.data54, d.data55, d.data56, d.data57, d.data58, d.data59, d.data60, d.data61, d.data62, d.data63, d.data64, d.data65, d.data66, d.data67, d.data68, d.data69, d.data70 from ( select k.*, m.pcsMaker, m.batteryMaker, p.name as plantName from t_kesco_data k, t_pms m, t_plant p where k.plantSeq = p.seq and m.plantSeq = p.seq and k.inputDate=#{inputDate} and k.inputHour=#{inputHour} ) k left join t_pmsdata_statistic_hour d on k.plantSeq = d.plantSeq and k.pmsdataSeq = d.seq and d.pcsIdx=0 and d.inputDate=#{inputDate} and d.inputHour=#{inputHour} and d.plantSeq = #{plantSeq} where k.inputDate = #{inputDate} and k.inputHour=#{inputHour} and k.plantSeq = #{plantSeq} order by d.inputDate desc, d.inputHour desc, k.createDatetime desc select * from t_timetable_kesco k where k.inputDate = #{inputDate} order by k.inputDate asc, k.inputHour asc