select p.*, d.pvPower, d.dayPvPower, d.createDatetime as pmsDatetime from ( select p.*, s.inputDate as lastday, s.todayEnergy as lastdayEnergy, s.todayHours as lastdayHours from ( select p.*, o.oseq, o.plantSeq, o.inputDate, o.inputHour, o.inputMinute, o.currPower, o.todayEnergy, o.todayHours, o.lifetimeEnergy, o.ovStatus, o.createDatetime as ivtDatetime from ( select p.seq, p.name, p.supplyPower, p.plantType, v.link, v.url1, v.url2, v.port, v.key1, v.key2, v.ivtQuantity, v.ivtType from t_plant p left join t_ivtjunc v on p.seq = v.plantSeq where p.plantType in ('02', '03') and p.plantStatus = #{plantStatus} and v.ivtStatus = #{ivtStatus} and p.seq = #{plantSeq} ) p left join t_ivtoverview o on p.seq = o.plantSeq and o.oseq = ( select max(oseq) as oseq from t_ivtoverview where inputDate=#{inputDate} and plantSeq = p.seq and inputHour = #{inputHour} ) ) p left join t_ivtoverview_day s on p.seq = s.plantSeq and s.inputDate = DATE_ADD(p.inputDate, INTERVAL -1 DAY) ) p left join t_pmsdata_${realtimeYear} d on p.seq = d.plantSeq and d.inputDate=#{inputDate} and d.seq = ( select max(seq) as seq from t_pmsdata_${realtimeYear} where plantSeq = p.seq and inputDate=#{inputDate} and inputHour = #{inputHour} ) order by p.seq desc select p.*, d.pvPower, d.dayPvPower, d.createDatetime as pmsDatetime from ( select p.*, s.inputDate as lastday, s.todayEnergy as lastdayEnergy, s.todayHours as lastdayHours from ( select p.*, o.oseq, o.plantSeq, o.inputDate, o.inputHour, o.inputMinute, o.currPower, o.todayEnergy, o.todayHours, o.lifetimeEnergy, o.ovStatus, o.createDatetime as lastDatetime from ( select p.seq, p.name as plantName, p.supplyPower, p.plantType, v.link, v.url1, v.url2, v.ivtQuantity, v.ivtType from t_plant p left join t_ivtjunc v on p.seq = v.plantSeq where p.plantType in ('02', '03') and p.seq = #{plantSeq} and p.plantStatus = #{plantStatus} and v.ivtStatus = #{ivtStatus} ) p left join t_ivtoverview o on p.seq = o.plantSeq and o.plantSeq = #{plantSeq} and o.inputDate=#{inputDate} and o.oseq = #{oseq} ) p left join t_ivtoverview_day s on p.seq = s.plantSeq and s.inputDate = DATE_ADD(p.inputDate, INTERVAL -1 DAY) ) p left join t_pmsdata_${realtimeYear} d on p.seq = d.plantSeq and d.inputDate=#{inputDate} and d.seq = ( select max(seq) as seq from t_pmsdata_${realtimeYear} where plantSeq = p.seq and inputDate=#{inputDate} and inputHour = p.inputHour and inputMinute like concat('%', substring(p.inputMinute, 1, 1), '%') and plantSeq = #{plantSeq} ) order by p.seq desc, p.oseq asc order by p.seq desc, p.oseq desc select * from t_ivtoverview_day where inputDate between #{str1} and #{str2} and plantSeq = #{plantSeq} order by inputDate asc SELECT R1.* FROM ( select p.*, d.pvPower, d.dayPvPower, d.createDatetime as pmsDatetime from ( select p.*, o.* from ( select p.seq, p.name, p.supplyPower, p.plantType, v.link, v.url1, v.url2, v.ivtQuantity, v.ivtType from t_plant p left join t_ivtjunc v on p.seq = v.plantSeq where p.plantType in ('02', '03') and p.seq = #{plantSeq} and v.ivtStatus = #{ivtStatus} ) p left join t_ivtdata o on p.seq = o.plantSeq and o.plantSeq = #{plantSeq} and o.oseq = #{oseq} ) p left join t_pmsdata_${realtimeYear} d on p.seq = d.plantSeq and d.inputDate=#{inputDate} and d.seq = ( select max(seq) as seq from t_pmsdata_${realtimeYear} where plantSeq = p.seq and inputDate=#{inputDate} and plantSeq = #{plantSeq} and inputHour = #{inputHour} ) order by seq desc, ivtIdx asc ) R1 LIMIT 0, 50 select p.*, d.pvPower, d.dayPvPower, d.createDatetime as pmsDatetime from ( select p.*, o.* from ( select p.seq, p.name, p.supplyPower, p.plantType, v.link, v.url1, v.url2, v.ivtQuantity, v.ivtType from t_plant p left join t_ivtjunc v on p.seq = v.plantSeq where p.plantType in ('02', '03') and p.seq = #{plantSeq} and v.ivtStatus = #{ivtStatus} ) p left join t_juncdata o on p.seq = o.plantSeq and o.plantSeq = #{plantSeq} and o.oseq = #{oseq} ) p left join t_pmsdata_${realtimeYear} d on p.seq = d.plantSeq and d.inputDate=#{inputDate} and d.seq = ( select max(seq) as seq from t_pmsdata_${realtimeYear} where plantSeq = p.seq and inputDate=#{inputDate} and plantSeq = #{plantSeq} and inputHour = #{inputHour} ) order by seq desc, ivtIdx asc select p.*, s.inputDate as lastday, s.todayEnergy as lastdayEnergy, s.todayHours as lastdayHours from ( select p.*, o.oseq, o.plantSeq, o.inputDate, o.inputHour, o.inputMinute, o.currPower, o.todayEnergy, o.todayHours, o.lifetimeEnergy, o.ovStatus, o.createDatetime as lastDatetime from t_plant p left join t_ivtoverview o on p.seq = o.plantSeq where p.plantType in ('02', '03') and p.plantStatus = #{plantStatus} and p.seq = #{plantSeq} and o.oseq = #{oseq} ) p left join t_ivtoverview_day s on p.seq = s.plantSeq and s.inputDate = DATE_ADD(p.inputDate, INTERVAL -1 DAY) order by p.seq desc select inputHour, inputMinute, count(oseq) as count from t_ivtoverview o where inputDate=#{inputDate} group by inputHour, inputMinute order by oseq desc select d.* from t_juncdata d, ( select plantSeq, max(oseq) oseq from t_ivtoverview where inputDate = #{inputDate} and oseq = #{oseq} and plantSeq = #{plantSeq} group by plantSeq ) s where d.plantSeq = s.plantSeq and d.oseq = s.oseq order by oseq asc, ivtIdx asc select d.* from t_ivtdata d, ( select plantSeq, max(oseq) oseq from t_ivtoverview where inputDate = #{inputDate} and oseq = #{oseq} and plantSeq = #{plantSeq} group by plantSeq ) s where d.plantSeq = s.plantSeq and d.oseq = s.oseq order by plantSeq asc, ivtIdx asc select o.inputHour, o.inputMinute, d.* from t_ivtoverview o, t_ivtdata d where o.oseq = d.oseq and o.plantSeq = #{plantSeq} and o.inputDate = #{inputDate} and ivtIdx = #{ivtIdx} order by o.oseq asc, d.ivtIdx asc select max(oseq) as oseq from t_ivtoverview insert into t_ivtdata ( oseq, plantSeq, ivtIdx, acPower, acFreq, apparentPower, reactivePower, acEnergy, dcCurr, dcVolt, dcPower, temp, powerFactor, lifetimeEnergy, ivtStatus, createDatetime ) values ( #{oseq}, #{plantSeq}, #{ivtIdx}, #{acPower}, #{acFreq}, #{apparentPower}, #{reactivePower}, #{acEnergy}, #{dcCurr}, #{dcVolt}, #{dcPower}, #{temp}, #{powerFactor}, #{lifetimeEnergy}, #{ivtStatus}, now() ) insert into t_ivtoverview ( oseq, plantSeq, inputDate, inputHour, inputMinute, currPower, todayEnergy, todayHours, lifetimeEnergy, ovStatus, createDatetime ) values ( #{oseq}, #{plantSeq}, #{inputDate}, #{inputHour}, #{inputMinute}, #{currPower}, #{todayEnergy}, #{todayHours}, #{lifetimeEnergy}, #{ovStatus}, now() ) update t_ivtjunc set url1 = #{url1}, url2 = #{url2}, port = #{port}, ivtStatus = #{ivtStatus}, ivtQuantity = #{ivtQuantity}, link = #{link}, key1 = #{key1}, key2 = #{key2}, ivtType = #{ivtType}, syncType = #{syncType}, updateDatetime = now() where plantSeq = #{plantSeq} insert into t_ivtjunc ( plantSeq, url1, url2, port, ivtStatus, ivtQuantity, link, key1, key2, ivtType, syncType, createDateTime, updateDatetime ) values ( #{plantSeq}, #{url1}, #{url2}, #{port}, #{ivtStatus}, #{ivtQuantity}, #{link}, #{key1}, #{key2}, #{ivtType}, #{syncType}, now(), now() )