SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(p.seq) as count from t_plant p where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and p.plantType = #{plantType} and p.name like concat('%', #{name}, '%') select p.* from t_plant p where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and p.plantType = #{plantType} and p.name like concat('%', #{name}, '%') order by p.seq desc select * from ( select p.seq as plantSeq, p.name, p.plantType, p.plantStatus, p.supplyPower, p.beginDate, p.omStartDate, p.omEndDate, p.createDatetime, k.customerId, k.aesKey, k.kescoStatus, k.protoVer, (select count(d.seq) from t_kesco_timetable d where d.plantSeq = p.seq and d.inputDate = #{inputDate}) as count, (select count(d.seq) from t_kesco_timetable d where d.plantSeq = p.seq and d.inputDate = #{inputDate} and d.sendStatus='01') as successCount, (select max(d.createDatetime) from t_kesco_timetable d where d.plantSeq = p.seq and d.inputDate = #{inputDate}) as pmsdataDatetime from t_plant p left join t_kesco k on p.seq = k.plantSeq where 1=1 and p.seq = #{plantSeq} and p.plantStatus = #{plantStatus} and k.kescoStatus = #{kescoStatus} and p.name like concat('%', #{name}, '%') order by p.seq desc ) d where d.successCount < #{successCount} select * from t_kesco_timetable k where inputDate = #{inputDate} and plantSeq = #{plantSeq} order by inputHour desc 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 t_kesco_timetable k, t_pmsdata_statistic_hour d where k.plantSeq = d.plantSeq and k.pmsdataSeq = d.seq and d.pcsIdx=0 and k.inputDate = #{inputDate} and d.inputDate=#{inputDate} and k.plantSeq = #{plantSeq} order by d.inputDate desc, d.inputHour desc select count(p.seq) as count from t_plant p left join t_pms m on p.seq = m.plantSeq where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and p.plantType = #{plantType} and m.pmsStatus = #{pmsStatus} and m.pcsMaker = #{pcsMaker} and m.batteryMaker = #{batteryMaker} and p.name like concat('%', #{name}, '%') select p.*, (select max(d.createDatetime) from t_pmsdata_${realtimeYear} d where d.plantSeq = p.seq and d.pcsIdx = 1 and d.inputDate = date_format(now(), '%Y-%m-%d')) as pmsdataDatetime, (select count(d.seq) from t_pmsdata_${realtimeYear} d where d.plantSeq = p.seq and d.pcsIdx = 1 and d.inputDate = date_format(now(), '%Y-%m-%d')) as count, m.plantSeq, m.ip, m.port, m.pmsStatus, m.startIdx, m.pmsMaker, m.pmsModel, m.pcsMaker, m.pcsVolume, m.pcsQuantity, m.batteryMaker, m.batteryModel, m.batteryVolume, m.batteryQuantity, (m.pcsVolume * m.pcsQuantity) as pcsPower, (m.batteryVolume * m.batteryQuantity) as batteryPower from t_plant p left join t_pms m on p.seq = m.plantSeq where 1=1 and p.seq = #{seq} and p.plantStatus = #{plantStatus} and p.plantType = #{plantType} and m.pmsStatus = #{pmsStatus} and m.pcsMaker = #{pcsMaker} and m.batteryMaker = #{batteryMaker} and p.name like concat('%', #{name}, '%') order by p.seq desc