SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(c.seq) as count from t_cs c, t_plant p where c.plantSeq = p.seq and c.csType = #{csType} and c.procStatus = #{procStatus} and c.procStatus > 10 and c.procStatus < 90 and c.procType = #{procType} and p.seq = #{plantSeq} select c.*, p.name as plantName from t_cs c, t_plant p where c.plantSeq = p.seq and c.csType = #{csType} and c.procStatus = #{procStatus} and c.procStatus > 10 and c.procStatus < 90 and c.procType = #{procType} and p.seq = #{plantSeq} order by c.seq desc select * from t_cs c where c.seq = #{seq} update t_cs set procStatus=#{procStatus}, procMemo=#{procMemo}, updateId=#{updateId}, updateDatetime=now() where seq=#{seq} insert into t_cs ( plantSeq, pcsIdx, timetableSeq, inputDate, inputHms, csType, procType, procStatus, pcsFaultStr, batteryFaultStr, updateId, updateDatetime, createId, createDatetime ) values ( #{plantSeq}, #{pcsIdx}, #{timetableSeq}, #{inputDate}, #{inputHms}, #{csType}, #{procType}, #{procStatus}, #{pcsFaultStr}, #{batteryFaultStr}, #{updateId}, now(), #{createId}, now() )