select d.* , s1.chargePower as y1ChargePower, s1.dischargePower as y1DischargePower from t_pmsdata_statistic_hour 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} order by d.plantSeq desc, d.inputHour desc select d.*, m.chargePower as y1ChargePower, m.dischargePower as y1DischargePower from t_pmsdata_statistic_day d left join t_pmsdata_statistic_month m on d.plantSeq = m.plantSeq and d.pcsIdx = m.pcsIdx and m.inputDate = concat(date_format(date_add(#{inputDate}, INTERVAL -1 MONTH), '%Y-%m'), '-01') and m.plantSeq = #{plantSeq} and m.pcsIdx = #{pcsIdx} where 1=1 and d.inputYear = #{inputYear} and d.inputMonth = #{inputMonth} and d.plantSeq = #{plantSeq} and d.pcsIdx = #{pcsIdx} order by d.inputYear desc, d.inputMonth desc, d.inputDay desc select d1.*, d2.inputDate from t_pmsdata_statistic_month d1 left join t_pmsdata_statistic_month d2 on d1.plantSeq = d2.plantSeq and d1.pcsIdx = d2.pcsIdx and d1.inputDate = date_add(d2.inputDate, INTERVAL 1 MONTH) and d2.plantSeq = #{plantSeq} and d2.pcsIdx = #{pcsIdx} where 1=1 and d1.plantSeq = #{plantSeq} and d1.pcsIdx = #{pcsIdx} and d1.inputYear = #{inputYear} order by d1.inputYear desc, d1.inputMonth desc