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.seq = #{seq} select d.*, s1.chargePower as y1ChargePower, s1.dischargePower as y1DischargePower from t_pmsdata_${realtimeYear} d left join t_pmsdata_statistic_day s1 on d.plantSeq = s1.plantSeq and d.pcsIdx = s1.pcsIdx and s1.plantSeq = #{plantSeq} and s1.pcsIdx = #{pcsIdx} and s1.inputDate = date_format(date_add(#{inputDate}, INTERVAL -1 DAY), '%Y-%m-%d') where 1=1 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.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}, '%') ) 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} group by plantSeq ) d2 where d.plantSeq = d2.plantSeq and d.timetableSeq = d2.timetableSeq and d.inputDate = #{inputDate} and d.pcsIdx=#{pcsIdx} and d.pcsIdx > 0 ) d on p.seq = d.plantSeq order by p.seq desc 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