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_2020 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} 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 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} d where pcsIdx=1 and d.inputDate = #{inputDate} group by d.plantseq ) d2 where d.plantSeq = d2.plantSeq and d.timetableSeq = d2.timetableSeq 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