SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(a.seq) as count from t_board a left join t_plant p on a.plantSeq = p.seq where 1=1 and ( a.plantSeq = #{plantSeq} or a.plantSeq = 0 ) and a.statusCode = #{statusCode} and a.beginDate >= #{todayDate} and a.beginDate <= #{beginDate} and a.endDate >= #{endDate} select a.*, p.name as plantName from t_board a left join t_plant p on a.plantSeq = p.seq where 1=1 and ( a.plantSeq = #{plantSeq} or a.plantSeq = 0 ) and a.statusCode = #{statusCode} and a.beginDate >= #{todayDate} and a.beginDate <= #{beginDate} and a.endDate >= #{endDate} order by a.beginDate desc, a.seq desc select a.*, p.name as plantName from t_board a left join t_plant p on a.plantSeq = p.seq where a.seq = #{seq} insert into t_board ( title, contents, beginDate, endDate, statusCode, plantSeq, createId, updateId, createDateTime, updateDatetime ) values ( #{title}, #{contents}, #{beginDate}, #{endDate}, #{statusCode}, #{plantSeq}, #{createId}, #{updateId}, now(), now() ) update t_board set title=#{title}, contents=#{contents}, beginDate=#{beginDate}, endDate=#{endDate}, statusCode=#{statusCode}, plantSeq=#{plantSeq}, updateId=#{updateId}, updateDatetime=now() where seq=#{seq}