a.id AS "id", a.member_code AS "memberCode", a.used_num AS "usedNum", a.total_num AS "totalNum", a.is_share AS "isShare", a.del_flag AS "delFlag", a.create_date AS "createDate" SELECT FROM dog_nose_raffle a WHERE a.id = #{id} SELECT FROM dog_nose_raffle a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} SELECT FROM dog_nose_raffle a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} INSERT INTO dog_nose_raffle( id, member_code, used_num, total_num, is_share, del_flag, create_date ) VALUES ( #{id}, #{memberCode}, #{usedNum}, #{totalNum}, #{isShare}, #{delFlag}, #{createDate} ) UPDATE dog_nose_raffle SET member_code = #{memberCode}, used_num = #{usedNum}, total_num = #{totalNum}, is_share = #{isShare} WHERE id = #{id} UPDATE dog_nose_raffle SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT FROM dog_nose_raffle a WHERE a.member_code = #{memberCode} and del_flag='0' limit 1 UPDATE dog_nose_raffle SET total_num=total_num+1, is_share='1' WHERE member_code = #{memberCode} and (is_share='0' or is_share is null) and del_flag='0' UPDATE dog_nose_raffle SET total_num=total_num+1 WHERE member_code = #{memberCode} and del_flag='0' UPDATE dog_nose_raffle SET used_num=used_num+1 WHERE member_code = #{memberCode} and total_num-used_num>0 and del_flag='0'