SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select p.name as name, k.* from t_kesco k, t_plant p where k.plantSeq = p.seq and p.name like concat('%', #{name}, '%') and p.seq = #{plantSeq} and k.kescoStatus = #{kescoStatus} order by p.seq desc select count(k.seq) as count from t_kesco_data k, t_plant p where k.plantSeq = p.seq and k.inputDate between #{str1} and #{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 between #{str1} and #{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 count(k.seq) as count 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} select k.*, d.pcsIdx, 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 k.timetableSeq desc, 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 select max(inputHour) as inputHour from t_timetable_kesco k where k.inputDate = #{inputDate} update t_kesco set customerId = #{customerId}, kescoStatus = #{kescoStatus}, rpsId = #{rpsId}, kepcoId = #{kepcoId}, specialStatus = #{specialStatus}, aesKey = #{aesKey}, protoVer = #{protoVer}, updateDatetime = now() where plantSeq = #{plantSeq} insert into t_kesco ( plantSeq, customerId, kescoStatus, rpsId, kepcoId, specialStatus, aesKey, protoVer, createDateTime, updateDatetime ) values ( #{plantSeq}, #{customerId}, #{kescoStatus}, #{rpsId}, #{kepcoId}, #{specialStatus}, #{aesKey}, #{protoVer}, now(), now() )