a.id AS "id", a.dog_id AS "dogId", a.state AS "state", a.pedigree_certified AS "pedigreeCertified", a.dog_breed AS "dogBreed", a.member_code AS "memberCode", a.price AS "price", a.door_to_door_flag AS "doorToDoorFlag", a.label AS "label", a.other_label AS "otherLabel", a.recommend_info AS "recommendInfo", a.cover_img_id AS "coverImgId", a.other_img_id AS "otherImgId", a.city AS "city", a.age AS "age", a.dog_pedigree_certified_change_id AS "dogPedigreeCertifiedChangeId", a.dog_newborn_count AS "dogNewbornCount", a.add_time AS "addTime", a.view_count AS "viewCount", 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 breeder_stud_dog a WHERE a.id = #{id} SELECT FROM breeder_stud_dog a a.del_flag = #{DEL_FLAG_NORMAL} AND a.dog_id = #{dogId} AND a.state = #{state} AND a.pedigree_certified = #{pedigreeCertified} AND a.dog_breed = #{dogBreed} AND a.member_code = #{memberCode} AND a.door_to_door_flag = #{doorToDoorFlag} AND a.add_time = #{addTime} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM breeder_stud_dog a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO breeder_stud_dog( id, dog_id, state, pedigree_certified, dog_breed, member_code, price, door_to_door_flag, label, other_label, recommend_info, cover_img_id, other_img_id, city, age, dog_pedigree_certified_change_id, dog_newborn_count, add_time, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{dogId}, #{state}, #{pedigreeCertified}, #{dogBreed}, #{memberCode}, #{price}, #{doorToDoorFlag}, #{label}, #{otherLabel}, #{recommendInfo}, #{coverImgId}, #{otherImgId}, #{city}, #{age}, #{dogPedigreeCertifiedChangeId}, #{dogNewbornCount}, #{addTime}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE breeder_stud_dog SET state = #{state}, price = #{price}, door_to_door_flag = #{doorToDoorFlag}, label = #{label}, other_label = #{otherLabel}, recommend_info = #{recommendInfo}, cover_img_id = #{coverImgId}, other_img_id = #{otherImgId}, city = #{city}, age = #{age}, dog_pedigree_certified_change_id = #{dogPedigreeCertifiedChangeId}, dog_newborn_count = #{dogNewbornCount}, add_time = #{addTime}, view_count = view_count+1, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE breeder_stud_dog SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} id, dog_id, pedigree_certified, dog_breed, member_code, price, door_to_door_flag, label, other_label, recommend_info, cover_img_id, other_img_id, city, age, view_count SELECT a.id AS "id", a.dog_id AS "dogId", a.pedigree_certified AS "pedigreeCertified", a.dog_breed AS "dogBreed", a.member_code AS "memberCode", a.price AS "price", a.door_to_door_flag AS "doorToDoorFlag", a.label AS "label", a.other_label AS "otherLabel", a.recommend_info AS "recommendInfo", a.cover_img_id AS "coverImgId", a.other_img_id AS "otherImgId", a.city AS "city", a.age AS "age", a.view_count AS "viewCount", b.birthdate AS "birthdate", b.name_en AS "nameEn" FROM ( SELECT FROM ( SELECT FROM ( SELECT FROM breeder_stud_dog a WHERE dog_breed IN #{item} AND state = '1' AND del_flag = '0' ORDER BY create_date DESC ) t1 UNION SELECT FROM ( SELECT FROM breeder_stud_dog a WHERE dog_breed NOT IN #{item} AND state = '1' AND del_flag = '0' ORDER BY create_date DESC ) t2 ) a LIMIT #{pageNo},#{pageSize} )a LEFT JOIN dog b ON a.dog_id = b.id SELECT a.id AS "id", a.dog_id AS "dogId", a.pedigree_certified AS "pedigreeCertified", a.dog_breed AS "dogBreed", a.member_code AS "memberCode", a.price AS "price", a.door_to_door_flag AS "doorToDoorFlag", a.label AS "label", a.other_label AS "otherLabel", a.recommend_info AS "recommendInfo", a.cover_img_id AS "coverImgId", a.other_img_id AS "otherImgId", a.city AS "city", a.age AS "age", a.view_count AS "viewCount", b.birthdate AS "birthdate", b.name_en AS "nameEn" FROM ( SELECT FROM breeder_stud_dog a WHERE a.state = '1' AND a.del_flag = '0' ORDER BY a.create_date DESC LIMIT #{pageNo},#{pageSize} )a LEFT JOIN dog b ON a.dog_id = b.id SELECT COUNT(1) FROM breeder_stud_dog a WHERE a.state = '1' AND a.del_flag = '0' SELECT FROM breeder_stud_dog a WHERE a.dog_id = #{dogId} AND a.del_flag = '0' UPDATE breeder_stud_dog SET member_code = #{memberCode} WHERE dog_id =#{dogId} SELECT , b.nickname AS "nickname" FROM ( SELECT a.id, a.dog_id, a.state, a.pedigree_certified, a.dog_breed, a.member_code, a.price, a.door_to_door_flag, a.label, a.other_label, a.recommend_info, a.cover_img_id, a.other_img_id, a.city, a.age, a.dog_pedigree_certified_change_id, a.dog_newborn_count, a.add_time, a.view_count, a.create_by, a.create_date, a.update_by, a.update_date, a.remarks, a.del_flag FROM breeder_stud_dog a a.member_code = #{memberCode} AND a.del_flag = '0' AND a.state = #{state} ORDER BY a.state DESC,a.add_time DESC LIMIT #{pageNo},#{pageSize} ) a LEFT JOIN dog b ON a.dog_id = b.id ORDER BY a.state DESC,a.add_time DESC SELECT COUNT(1) FROM breeder_stud_dog a a.member_code = #{memberCode} AND a.del_flag = '0' AND a.state = #{state} SELECT a.dog_breed FROM breeder_stud_dog a WHERE a.state = '1' AND a.del_flag = '0' SELECT a.id AS "id", a.dog_id AS "dogId", a.pedigree_certified AS "pedigreeCertified", a.dog_breed AS "dogBreed", a.member_code AS "memberCode", a.price AS "price", a.door_to_door_flag AS "doorToDoorFlag", a.label AS "label", a.other_label AS "otherLabel", a.recommend_info AS "recommendInfo", a.cover_img_id AS "coverImgId", a.other_img_id AS "otherImgId", a.city AS "city", a.age AS "age", a.view_count AS "viewCount", b.birthdate AS "birthdate", b.name_en AS "nameEn" FROM ( SELECT FROM breeder_stud_dog a WHERE a.state = '1' AND a.del_flag = '0' AND a.dog_breed = #{dogBreed} AND a.price = ]]> #{priceMin} AND a.price #{priceMax} AND a.city = #{city} AND a.door_to_door_flag = #{doorToDoorFlag} AND a.dog_newborn_count ]]> 0 AND a.other_img_id LIKE '%,%' AND LEFT(a.label,1) IN ('1','2','3','4','5','6','7') AND SUBSTRING(a.label,2,1) IN ('',',') AND a.dog_pedigree_certified_change_id != '' AND a.age = 5 ORDER BY a.add_time DESC LIMIT #{pageNo},#{pageSize} )a LEFT JOIN dog b ON a.dog_id = b.id SELECT COUNT(1) FROM breeder_stud_dog a WHERE a.state = '1' AND a.del_flag = '0' AND a.dog_breed = #{dogBreed} AND a.price = ]]> #{priceMin} AND a.price #{priceMax} AND a.city = #{city} AND a.door_to_door_flag = #{doorToDoorFlag} AND a.dog_newborn_count ]]> 0 AND a.other_img_id LIKE '%,%' AND LEFT(a.label,1) IN ('1','2','3','4','5','6','7') AND SUBSTRING(a.label,2,1) IN ('',',') AND a.dog_pedigree_certified_change_id != '' AND a.age = 5 INSERT INTO breeder_stud_dog_search_parameter( dog_breed, city, price_min, price_max, create_date ) VALUES ( #{dogBreed}, #{city}, #{priceMin}, #{priceMax}, now() ) SELECT a.id AS "id", a.dog_id AS "dogId", a.pedigree_certified AS "pedigreeCertified", a.dog_breed AS "dogBreed", a.member_code AS "memberCode", a.price AS "price", a.door_to_door_flag AS "doorToDoorFlag", a.label AS "label", a.other_label AS "otherLabel", a.recommend_info AS "recommendInfo", a.cover_img_id AS "coverImgId", a.other_img_id AS "otherImgId", a.city AS "city", a.age AS "age", a.view_count AS "viewCount", b.birthdate AS "birthdate", b.name_en AS "nameEn" FROM ( SELECT FROM breeder_stud_dog a WHERE a.state = '1' AND a.del_flag = '0' ORDER BY a.top_sort DESC,a.view_count DESC LIMIT #{pageSize} )a LEFT JOIN dog b ON a.dog_id = b.id