a.id AS "id", a.main_show_id AS "mainShowId", a.count AS "count", a.referees AS "referees", a.region AS "region", a.province AS "province", a.city AS "city", a.start_date AS "startDate", a.end_date AS "endDate", a.create_by AS "createBy.id", a.create_date AS "createDate", a.del_flag AS "delFlag" SELECT FROM show_referee_delegate_log a WHERE a.id = #{id} SELECT FROM show_referee_delegate_log a a.del_flag = #{DEL_FLAG_NORMAL} AND a.main_show_id = #{mainShowId} AND a.referees like concat('%',#{referees},'%') AND a.region = #{region} AND a.province = #{province} AND a.city = #{city} AND a.start_date >= #{startDate} ORDER BY a.main_show_id DESC ORDER BY a.main_show_id DESC SELECT FROM show_referee_delegate_log a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} SELECT count(1) FROM show_referee_delegate_log a a.del_flag = '0' AND a.main_show_id = #{mainShowId} INSERT INTO show_referee_delegate_log( id, main_show_id, count, referees, region, province, city, start_date, end_date, create_by, create_date, del_flag ) VALUES ( #{id}, #{mainShowId}, #{count}, #{referees}, #{region}, #{province}, #{city}, #{startDate}, #{endDate}, #{createBy.id}, #{createDate}, #{delFlag} ) UPDATE show_referee_delegate_log SET main_show_id = #{mainShowId}, count = #{count}, referees = #{referees}, region = #{region}, province = #{province}, city = #{city}, start_date = #{startDate}, end_date = #{endDate} WHERE id = #{id} UPDATE show_referee_delegate_log SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}