SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(p.seq) as count from t_plant p where 1=1 and p.seq = #{seq} and p.seq = #{pms.pcsMaker} and p.seq = #{pms.batteryMaker} select p.*, (select max(d.createDatetime) from t_pmsdata_2020 d where d.plantSeq = p.seq and d.pcsIdx = 1 and d.inputDate = date_format(now(), '%Y-%m-%d')) as pmsdataDatetime from t_plant p where 1=1 order by p.seq desc select p.*, (select max(d.createDatetime) from t_pmsdata_2020 d where d.plantSeq = p.seq and d.pcsIdx = 1 and d.inputDate = date_format(now(), '%Y-%m-%d')) as pmsdataDatetime, m.plantSeq, m.ip, m.port, m.status, m.startIdx, m.pmsMaker, m.pmsModel, m.pcsMaker, m.pcsVolume, m.pcsQuantity, m.batteryMaker, m.batteryModel, m.batteryVolume, m.batteryQuantity from t_plant p left join t_pms m on p.seq = m.plantSeq where 1=1 and p.seq = #{seq} and p.seq = #{pms.pcsMaker} and p.seq = #{pms.batteryMaker} order by p.seq desc