a.id AS "id", a.name AS "name", a.name_en AS "nameEn", a.picture AS "picture", a.involved_into AS "involvedInto", a.involved_into_en AS "involvedIntoEn", a.elected_into AS "electedInto", a.elected_into_en AS "electedIntoEn", a.title AS "title", a.title_en AS "titleEn", a.experience AS "experience", a.experience_en AS "experienceEn", a.kennel_name AS "kennelName", a.kennel_name_en AS "kennelNameEn", a.breed_type AS "breedType", a.breed_type_en AS "breedTypeEn", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag" SELECT FROM show_advisor a WHERE a.id = #{id} SELECT FROM show_advisor a a.del_flag = #{DEL_FLAG_NORMAL} AND a.name = #{name} ORDER BY ${page.orderBy} ORDER BY a.createDate ASC ORDER BY a.update_date DESC SELECT FROM show_advisor a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO show_advisor( id, name, name_en, picture, involved_into, involved_into_en, elected_into, elected_into_en, title, title_en, experience, experience_en, kennel_name, kennel_name_en, breed_type, breed_type_en, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{name}, #{nameEn}, #{picture}, #{involvedInto}, #{involvedIntoEn}, #{electedInto}, #{electedIntoEn}, #{title}, #{titleEn}, #{experience}, #{experienceEn}, #{kennelName}, #{kennelNameEn}, #{breedType}, #{breedTypeEn}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE show_advisor SET name = #{name}, name_en = #{nameEn}, picture = #{picture}, involved_into = #{involvedInto}, involved_into_en = #{involvedIntoEn}, elected_into = #{electedInto}, elected_into_en = #{electedIntoEn}, title = #{title}, title_en = #{titleEn}, experience = #{experience}, experience_en = #{experienceEn}, kennel_name = #{kennelName}, kennel_name_en = #{kennelNameEn}, breed_type = #{breedType}, breed_type_en = #{breedTypeEn}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE show_advisor SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}