select count(d.seq) as count from t_pmsdata_${realtimeYear} d where 1=1 and p.plantSeq = #{plantSeq} select * from t_pmsdata_${realtimeYear} d where 1=1 and d.plantSeq = #{plantSeq} and d.inputDate = #{inputDate} order by plantSeq desc, inputDate desc, inputHour desc, 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