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 kescodataDatetime 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 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} where k.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 m.pmsStatus = #{pmsStatus} and p.plantType = #{plantType} 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 m.pmsStatus = #{pmsStatus} and p.plantType = #{plantType} and m.pcsMaker = #{pcsMaker} and m.batteryMaker = #{batteryMaker} and p.name like concat('%', #{name}, '%') order by p.seq desc select k.plantSeq, p.name as plantName, k.inputDate, count(k.seq) as count, sum(k.succCount) as succCount from ( select t1.*, CASE WHEN sendStatus='01' THEN '1' ELSE '0' END AS succCount from t_kesco_timetable t1 where inputDate like concat(#{inputDate}, '-__') and t1.plantSeq = #{plantSeq} ) k, t_plant p where k.plantSeq = p.seq group by k.plantSeq, k.inputDate order by k.plantSeq, k.inputDate