SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} t_sms and p.seq in ( ${plantSeqs} ) select a.*, p.name as plantName from a left join t_plant p on a.plantSeq = p.seq where 1=1 and a.result = #{result} and a.plantSeq = #{plantSeq} order by a.seq desc select count(a.seq) as count from a left join t_plant p on a.plantSeq = p.seq where 1=1 and a.result = #{result} and a.plantSeq = #{plantSeq} insert into ( plantSeq, title, receiver, sender, result, createId, createDateTime ) values ( #{plantSeq}, #{title}, #{receiver}, #{sender}, #{result}, #{createId}, now() )