SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(d.seq) as count from t_pmsdata_${realtimeYear} d where 1=1 and d.plantSeq = #{plantSeq} and d.pcsIdx = #{pcsIdx} and d.inputDate = #{inputDate} and d.seq = #{seq} and d.timetableSeq = #{timetableSeq} and d.inputDate >= #{str1} and d.inputDate <= #{str2} select d.*, m.pcsMaker, m.batteryMaker, p.name as plantName from ( select d.*, s.y1ChargePower, s.y1DischargePower, s.y1PvPower, s.y2ChargePower, s.y2DischargePower, s.y2PvPower from t_pmsdata_2020 d left join ( select s1.plantSeq, s1.pcsIdx, s1.chargePower as y1ChargePower, s1.dischargePower as y1DischargePower, s1.pvPower as y1PvPower, s2.chargePower as y2ChargePower, s2.dischargePower as y2DischargePower, s2.pvPower as y2PvPower from t_pmsdata_statistic_day s1 , t_pmsdata_statistic_day s2 where 1=1 and s1.plantSeq = #{plantSeq} and s1.pcsIdx = #{pcsIdx} and s1.inputDate = #{str3} and s2.plantSeq = #{plantSeq} and s2.pcsIdx = 0 and s2.inputDate = #{str4} and s1.plantSeq = s2.plantSeq and s1.pcsIdx = s2.pcsIdx ) s on d.plantSeq = s.plantSeq and d.pcsIdx = s.pcsIdx where 1=1 and d.plantSeq = #{plantSeq} and d.pcsIdx = #{pcsIdx} and d.inputDate = #{inputDate} and d.timetableSeq = #{timetableSeq} and d.inputDate >= #{str1} and d.inputDate <= #{str2} ) d, t_pms m, t_plant p where d.plantSeq = p.seq and d.plantSeq = m.plantSeq order by d.plantSeq asc, d.inputDate asc, d.inputHour asc, d.inputMinute asc order by d.plantSeq desc, d.inputDate desc, d.inputHour desc, d.inputMinute desc select count(d.seq) as count from t_pmsdata_${realtimeYear} d, t_plant p where p.seq = d.plantSeq and d.pcsIdx > 0 and (d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0 or d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0 ) and d.data51 <> 0 and d.data56 <> 0 and ( d.data51 < #{data61} or d.data51 > #{data62} or d.data52 < #{data61} or d.data52 > #{data62} or d.data56 < #{data63} or d.data56 > #{data64} or d.data57 < #{data63} or d.data57 > #{data64} ) and d.plantSeq = #{plantSeq} and d.pcsIdx = #{pcsIdx} and d.inputDate = #{inputDate} and d.seq = #{seq} and d.inputDate >= #{str1} and d.inputDate <= #{str2} select p.name as plantName, d.* from t_pmsdata_${realtimeYear} d, t_plant p where p.seq = d.plantSeq and d.pcsIdx > 0 and (d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0 or d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0 ) and d.data51 <> 0 and d.data56 <> 0 and ( d.data51 < #{data61} or d.data51 > #{data62} or d.data52 < #{data61} or d.data52 > #{data62} or d.data56 < #{data63} or d.data56 > #{data64} or d.data57 < #{data63} or d.data57 > #{data64} ) and d.plantSeq = #{plantSeq} and d.pcsIdx = #{pcsIdx} and d.inputDate = #{inputDate} and d.seq = #{seq} and d.inputDate >= #{str1} and d.inputDate <= #{str2} order by d.inputDate desc, d.inputHour desc, d.inputMinute desc, d.plantSeq asc select p.seq as plantSeq, p.plantName, p.plantStatus, p.supplyPower, p.pmsStatus, p.pcsMaker, p.pcsQuantity, d.seq, d.pcsIdx, d.timetableSeq, d.inputDate, d.inputHour, d.inputMinute, 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, d.createDatetime, d.count from ( select p.seq, p.name as plantName, p.plantStatus, p.supplyPower, pm.pmsStatus, pm.pcsMaker, pm.pcsQuantity from t_plant p, t_pms pm where p.seq = pm.plantSeq and p.plantStatus = #{plantStatus} and pm.pmsStatus = #{pmsStatus} and p.name like concat('%', #{plantName}, '%') and p.plantStatus = #{plantStatus} and p.seq = #{plantSeq} ) p left join ( select d.*, d2.count from t_pmsdata_${realtimeYear} d, ( select plantSeq, max(timetableSeq) as timetableSeq, count(seq) as count from t_pmsdata_${realtimeYear} where pcsIdx=1 and inputDate = #{inputDate} and plantSeq = #{plantSeq} group by plantSeq ) d2 where d.plantSeq = d2.plantSeq and d.timetableSeq = d2.timetableSeq and d.inputDate = #{inputDate} and d.plantSeq = #{plantSeq} and d.pcsIdx=#{pcsIdx} and d.pcsIdx > 0 ) d on p.seq = d.plantSeq order by p.seq desc, d.pcsIdx asc select p.name as plantName, d.* from t_pmsdata_${realtimeYear} d, t_plant p where d.plantSeq = p.seq and d.inputDate=#{inputDate} and d.pcsIdx > 0 and ( d.data25 > 0 or d.data62 > 0 or d.data63 > 0 or d.data64 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) order by p.seq asc, d.pcsIdx asc select p.name as plantName, d.* from t_pmsdata_${realtimeYear} d, t_plant p where d.plantSeq = p.seq and d.inputDate=#{inputDate} and d.pcsIdx > 0 and ( d.data28 > 0 or d.data29 > 0 or d.data69 > 0 or d.data70 > 0) and d.timetableSeq = (select currSeq from t_sequence where seq=10) order by p.seq asc, d.pcsIdx asc select * from t_timetable_pms k where k.inputDate = #{inputDate} order by k.inputDate desc, k.inputHour desc select count(d.seq) as count from t_pmsdata_${realtimeYear} d, t_plant p, t_pms m where d.plantSeq = p.seq and p.seq = m.plantSeq and d.inputDate=#{inputDate} and d.data51 <> 0 and (d.data51 < #{data61} or d.data51 > #{data62} or d.data52 < #{data61} or d.data52 > #{data62} or d.data56 < #{data63} or d.data56 > #{data64} or d.data57 < #{data63} or d.data57 > #{data64}) and d.plantSeq = #{plantSeq} and d.inputHour = #{inputHour} select d.*, p.name as plantName, m.pcsMaker, m.pcsVolume, m.pcsQuantity, m.batteryMaker, m.batteryModel, m.batteryVolume, m.batteryQuantity from t_pmsdata_${realtimeYear} d, t_plant p, t_pms m where d.plantSeq = p.seq and p.seq = m.plantSeq and d.inputDate=#{inputDate} and d.data51 <> 0 and (d.data51 < #{data61} or d.data51 > #{data62} or d.data52 < #{data61} or d.data52 > #{data62} or d.data56 < #{data63} or d.data56 > #{data64} or d.data57 < #{data63} or d.data57 > #{data64}) and d.plantSeq = #{plantSeq} and d.inputHour = #{inputHour} order by d.inputHour desc, d.plantSeq desc