a.id AS "id", a.logout AS "logout", a.birth_certificate_level_code AS "birthCertificateLevelCode", a.pedigree_certified_code AS "pedigreeCertifiedCode", a.dog_owner AS "dogOwner", a.member_code AS "memberCode", a.second_dog_owner AS "secondDogOwner", a.second_owner_member_num AS "secondOwnerMemberNum", a.breeder AS "breeder", a.second_breeder AS "secondBreeder", a.name_cn AS "nameCn", a.name_en AS "nameEn", a.nickname AS "nickname", a.gender AS "gender", a.dog_breed AS "dogBreed", a.show_dog_breed AS "showDogBreed", a.birthdate AS "birthdate", a.identification_flag AS "identificationFlag", a.cab_passport AS "cabPassport", a.cab_register_code AS "cabRegisterCode", a.dna_save_way AS "dnaSaveWay", a.is_dna_parents_compare AS "isDnaParentsCompare", a.gold_certified_type AS "goldCertifiedType", a.gold_certified_state AS "goldCertifiedState", a.wool AS "wool", a.color_flag AS "colorFlag", a.special_flag AS "specialFlag", a.hip_qualification_result AS "hipQualificationResult", a.elbow_qualification_result AS "elbowQualificationResult", a.dna AS "dna", a.sampling_code AS "samplingCode", a.breed_qualification AS "breedQualification", a.inbreeding AS "inbreeding", a.referee_evaluation AS "refereeEvaluation", a.show_level AS "showLevel", a.show_grade AS "showGrade", a.test_level AS "testLevel", a.test_grade AS "testGrade", a.archives_code AS "archivesCode", a.fdog_pedigree_certified AS "fdogPedigreeCertified", a.mdog_pedigree_certified AS "mdogPedigreeCertified", a.fmdog_breed_certified_code AS "fmdogBreedCertifiedCode", a.inbreeding_print AS "inbreedingPrint", a.print_state AS "printState", a.pedigree_certified_old AS "pedigreeCertifiedOld", a.pedigree_certified_en AS "pedigreeCertifiedEn", a.operator AS "operator", a.dna_pay_state AS "dnaPayState", a.breed_pay_state AS "breedPayState", a.running_number AS "runningNumber", a.breeder_member_code AS "breederMemberCode", a.dog_generation AS "dogGeneration", a.breed_reviewe AS "breedReviewe", a.disqualification_number AS "disqualificationNumber", 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", a.dog_state AS "dogState", a.call_name AS "callName", a.business_ban AS "businessBan", a.show_ban AS "showBan", a.picture_review_state AS "pictureReviewState", a.picture AS "picture", a.picture_review_remark AS "pictureReviewRemark", a.change_ban AS "changeBan", a.print_time AS "printTime" a.id AS "id", a.logout AS "logout", a.birth_certificate_level_code AS "birthCertificateLevelCode", a.pedigree_certified_code AS "pedigreeCertifiedCode", a.dog_owner AS "dogOwner", a.member_code AS "memberCode", a.second_dog_owner AS "secondDogOwner", a.second_owner_member_num AS "secondOwnerMemberNum", a.breeder AS "breeder", a.second_breeder AS "secondBreeder", a.name_cn AS "nameCn", a.name_en AS "nameEn", a.nickname AS "nickname", a.gender AS "gender", a.dog_breed AS "dogBreed", a.show_dog_breed AS "showDogBreed", a.birthdate AS "birthdate", a.identification_flag AS "identificationFlag", a.cab_passport AS "cabPassport", a.cab_register_code AS "cabRegisterCode", a.dna_save_way AS "dnaSaveWay", a.is_dna_parents_compare AS "isDnaParentsCompare", a.gold_certified_type AS "goldCertifiedType", a.gold_certified_state AS "goldCertifiedState", a.wool AS "wool", a.color_flag AS "colorFlag", a.special_flag AS "specialFlag", a.hip_qualification_result AS "hipQualificationResult", a.elbow_qualification_result AS "elbowQualificationResult", a.dna AS "dna", a.sampling_code AS "samplingCode", a.breed_qualification AS "breedQualification", a.inbreeding AS "inbreeding", a.referee_evaluation AS "refereeEvaluation", a.show_level AS "showLevel", a.show_grade AS "showGrade", a.test_level AS "testLevel", a.test_grade AS "testGrade", a.archives_code AS "archivesCode", a.fdog_pedigree_certified AS "fdogPedigreeCertified", a.mdog_pedigree_certified AS "mdogPedigreeCertified", a.fmdog_breed_certified_code AS "fmdogBreedCertifiedCode", a.inbreeding_print AS "inbreedingPrint", a.print_state AS "printState", a.pedigree_certified_old AS "pedigreeCertifiedOld", a.pedigree_certified_en AS "pedigreeCertifiedEn", a.operator AS "operator", a.dna_pay_state AS "dnaPayState", a.breed_pay_state AS "breedPayState", a.running_number AS "runningNumber", a.breeder_member_code AS "breederMemberCode", a.dog_generation AS "dogGeneration", a.breed_reviewe AS "breedReviewe", a.disqualification_number AS "disqualificationNumber", 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", a.dog_state AS "dogState", a.call_name AS "callName", a.business_ban AS "businessBan", a.show_ban AS "showBan", a.picture_review_state AS "pictureReviewState", a.picture AS "picture", a.picture_review_remark AS "pictureReviewRemark", a.ecert_flag as "ecertFlag", a.change_ban AS "changeBan" SELECT FROM dog a WHERE a.identification_flag = #{identificationFlag} AND a.del_flag = '0' ORDER BY a.create_date DESC LIMIT 1 SELECT FROM dog a WHERE a.del_flag = '0' AND a.fmdog_breed_certified_code = #{key} AND 1 != 1 SELECT FROM dog a WHERE a.del_flag = '0' AND (a.fdog_pedigree_certified = #{key} OR a.mdog_pedigree_certified = #{key}) SELECT FROM dog a WHERE a.del_flag = '0' AND a.fdog_pedigree_certified = #{key} SELECT FROM dog a WHERE a.del_flag = '0' AND a.mdog_pedigree_certified = #{key} SELECT , b.member_site AS "dogOwnerSite" FROM dog a LEFT JOIN sys_member b ON a.member_code = b.member_code WHERE a.id = #{id} SELECT FROM dog a a.del_flag = #{DEL_FLAG_NORMAL} a.del_flag = #{dogState} AND (a.birth_certificate_level_code = #{birthCertificateLevelCode} or a.cab_passport=#{birthCertificateLevelCode}) AND a.gold_certified_type = #{goldCertifiedType} AND a.gold_certified_state = #{goldCertifiedState} AND a.sampling_code = #{samplingCode} AND a.identification_flag = #{identificationFlag} AND (a.pedigree_certified_code like concat('%',#{pedigreeCertifiedCode},'%') or a.identification_flag = #{pedigreeCertifiedCode}) AND (a.dog_owner = #{dogOwner} or member_code = #{dogOwner}) AND a.name_en LIKE CONCAT('%',#{nameEn},'%') AND a.birthdate = #{birthdate} AND a.color_flag = #{colorFlag} AND a.dog_breed ${sqlMap.dogBreedMap} AND a.fdog_pedigree_certified like concat('%',#{fdogPedigreeCertified},'%') AND a.mdog_pedigree_certified like concat('%',#{mdogPedigreeCertified},'%') AND a.dog_state = #{dogState} AND a.member_code = #{memberCode} AND a.fmdog_breed_certified_code = #{fmdogBreedCertifiedCode} AND a.pedigree_certified_en like concat('%',#{pedigreeCertifiedEn},'%') AND a.dna_save_way = #{dnaSaveWay} AND a.dog_generation = #{dogGeneration} AND a.is_dna_parents_compare = #{isDnaParentsCompare} AND a.dog_breed = #{dogBreed} AND a.gender = #{gender} AND a.picture_review_state = #{pictureReviewState} AND YEAR(a.birthdate) = #{birthdateYear} AND a.cab_passport LIKE CONCAT('%',#{cabPassportLike},'%') AND a.birthdate DATE_SUB(CURDATE(),interval 1 YEAR) AND a.ecert_flag = #{ecertFlag} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog( id, birth_certificate_level_code, pedigree_certified_code, dog_owner, member_code, second_dog_owner, second_owner_member_num, breeder, second_breeder, name_cn, name_en, gender, dog_breed, show_dog_breed, birthdate, identification_flag, cab_passport, dna_save_way, is_dna_parents_compare, gold_certified_type, gold_certified_state, color_flag, special_flag, hip_qualification_result, elbow_qualification_result, dna, breed_qualification, referee_evaluation, show_level, show_grade, test_level, test_grade, fdog_pedigree_certified, mdog_pedigree_certified, fmdog_breed_certified_code, print_state, pedigree_certified_old, pedigree_certified_en, dna_pay_state, breed_pay_state, breeder_member_code, dog_generation, breed_reviewe, disqualification_number, business_ban, show_ban, create_by, create_date, update_by, update_date, remarks, del_flag, call_name, dog_state, ecert_flag, change_ban ) VALUES ( #{id}, #{birthCertificateLevelCode}, #{pedigreeCertifiedCode}, #{dogOwner}, #{memberCode}, #{secondDogOwner}, #{secondOwnerMemberNum}, #{breeder}, #{secondBreeder}, #{nameCn}, #{nameEn}, #{gender}, #{dogBreed}, #{showDogBreed}, #{birthdate}, #{identificationFlag}, #{cabPassport}, #{dnaSaveWay}, #{isDnaParentsCompare}, #{goldCertifiedType}, #{goldCertifiedState}, #{colorFlag}, #{specialFlag}, #{hipQualificationResult}, #{elbowQualificationResult}, #{dna}, #{breedQualification}, #{refereeEvaluation}, #{showLevel}, #{showGrade}, #{testLevel}, #{testGrade}, #{fdogPedigreeCertified}, #{mdogPedigreeCertified}, #{fmdogBreedCertifiedCode}, #{printState}, #{pedigreeCertifiedOld}, #{pedigreeCertifiedEn}, #{dnaPayState}, #{breedPayState}, #{breederMemberCode}, #{dogGeneration}, #{breedReviewe}, #{disqualificationNumber}, #{businessBan}, #{showBan}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{callName}, #{dogState}, #{ecertFlag}, #{changeBan} ) UPDATE dog SET birth_certificate_level_code = #{birthCertificateLevelCode}, pedigree_certified_code = #{pedigreeCertifiedCode}, second_dog_owner = #{secondDogOwner}, second_owner_member_num = #{secondOwnerMemberNum}, second_breeder = #{secondBreeder}, name_cn = #{nameCn}, name_en = #{nameEn}, nickname = #{nickname}, gender = #{gender}, dog_breed = #{dogBreed}, birthdate = #{birthdate}, identification_flag = #{identificationFlag}, cab_passport = #{cabPassport}, cab_register_code = #{cabRegisterCode}, color_flag = #{colorFlag}, special_flag = #{specialFlag}, hip_qualification_result = #{hipQualificationResult}, elbow_qualification_result = #{elbowQualificationResult}, dna = #{dna}, sampling_code = #{samplingCode}, gold_certified_type = #{goldCertifiedType}, gold_certified_state = #{goldCertifiedState}, breed_qualification = #{breedQualification}, referee_evaluation = #{refereeEvaluation}, show_level = #{showLevel}, show_grade = #{showGrade}, test_level = #{testLevel}, test_grade = #{testGrade}, fdog_pedigree_certified = #{fdogPedigreeCertified}, mdog_pedigree_certified = #{mdogPedigreeCertified}, fmdog_breed_certified_code = #{fmdogBreedCertifiedCode}, pedigree_certified_old = #{pedigreeCertifiedOld}, pedigree_certified_en = #{pedigreeCertifiedEn}, disqualification_number = #{disqualificationNumber}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, call_name = #{callName}, picture_review_state = #{pictureReviewState}, picture_review_remark = #{pictureReviewRemark}, picture = #{picture}, business_ban = #{businessBan}, dog_state = #{dogState}, show_ban = #{showBan} , ecert_flag = #{ecertFlag} , change_ban = #{changeBan} WHERE id = #{id} UPDATE dog SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE dog SET second_breeder = #{secondBreeder} WHERE id = #{id} SELECT , b.member_site AS "dogOwnerSite" FROM dog a LEFT JOIN sys_member b ON a.member_code = b.member_code WHERE a.pedigree_certified_code = #{_parameter} AND a.del_flag = '0' limit 1 SELECT , b.member_site AS "dogOwnerSite" FROM dog a LEFT JOIN sys_member b ON a.member_code = b.member_code WHERE (a.pedigree_certified_code = #{_parameter} or a.pedigree_certified_en = #{_parameter}) AND a.del_flag = '0' limit 1 SELECT FROM dog a WHERE a.pedigree_certified_code = #{_parameter} limit 1 update dog set dog_owner = #{dogOwner}, member_code = #{memberCode} where id = #{id} SELECT FROM dog a WHERE a.identification_flag = #{_parameter} AND a.del_flag = '0' limit 1 SELECT FROM dog a WHERE a.identification_flag = #{_parameter} AND a.del_flag = '0' AND a.pedigree_certified_code LIKE "CKU-%" update dog set print_state = #{printState}, update_by = #{updateBy.id}, update_date = #{updateDate}, operator=#{operator}, print_time = now() where id = #{id} update dog set show_dog_breed = #{showDogBreed} where id = #{id} update dog set dog_generation = #{dogGeneration} where id = #{id} SELECT FROM dog a a.del_flag = '0' AND date_format(a.create_date, '%Y-%m-%d') = ]]> date_format(#{startDate}, '%Y-%m-%d') AND date_format(a.create_date, '%Y-%m-%d') date_format(#{endDate}, '%Y-%m-%d') AND a.create_date is null ORDER BY a.create_date ASC SELECT FROM dog a WHERE a.pedigree_certified_en = #{pedigreeCertifiedEn} AND a.del_flag = '0' LIMIT 1 SELECT FROM dog a WHERE a.pedigree_certified_en = #{pedigreeCertifiedEn} AND LEFT(a.pedigree_certified_code,3) = 'CKU' AND a.del_flag = '0' LIMIT 1 SELECT FROM dog a WHERE (a.pedigree_certified_en = #{pedigreeCertifiedEn} or pedigree_certified_code = #{pedigreeCertifiedEn}) AND a.del_flag = '0' LIMIT 1 select id,pedigree_certified_code from dog where pedigree_certified_code=#{pedigreeCertifiedCode} and del_flag = '0' select id,identification_flag from dog where identification_flag=#{identificationFlag} and del_flag = '0' select pedigree_certified_en from dog where fmdog_breed_certified_code = #{fmdogBreedCertifiedCode} update dog set identification_flag=#{identificationFlag} where id = #{id} select id, birth_certificate_level_code, pedigree_certified_code, dog_owner, member_code, print_state, name_cn, name_en, nickname, gender, dog_breed from dog where birth_certificate_level_code=#{birthCertificateLevelCode} and del_flag='0' SELECT birth_certificate_level_code, max(create_date) max_create_date, min(create_date) min_create_date FROM dog WHERE del_flag='0' GROUP BY birth_certificate_level_code HAVING COUNT(1)>1 ORDER BY create_date desc UPDATE dog d SET d.del_flag ='1' WHERE id in #{dogId} UPDATE dog d SET d.del_flag ='1' WHERE d.birth_certificate_level_code = #{birthCertificateLevelCode} AND ( SELECT m.total FROM ( SELECT COUNT(1) total FROM dog WHERE del_flag = '0' AND birth_certificate_level_code = #{birthCertificateLevelCode} GROUP BY birth_certificate_level_code) m ) > 1 AND d.create_date = ( SELECT t.min_create_date FROM ( SELECT MIN(create_date) min_create_date FROM dog WHERE birth_certificate_level_code = #{birthCertificateLevelCode}) t) SELECT pedigree_certified_en, fmdog_breed_certified_code FROM dog WHERE pedigree_certified_en IS NOT NULL AND pedigree_certified_en ]]> '' AND fmdog_breed_certified_code IS NOT NULL AND fmdog_breed_certified_code ]]> '' AND pedigree_certified_en=#{overseasPedigreeCertified} SELECT COUNT(1) FROM dog a WHERE a.member_code = #{memberCode} AND a.del_flag = '0' SELECT dog_breed FROM dog WHERE member_code = #{memberCode} AND gender = '1' AND birthdate = ]]> DATE_SUB(CURDATE(),interval 10 YEAR) AND birthdate DATE_SUB(CURDATE(),interval 1 YEAR) AND dog_state = '0' AND business_ban = '0' AND del_flag = '0' GROUP BY dog_breed ORDER BY COUNT(dog_breed) DESC SELECT dog_breed FROM dog WHERE member_code = #{memberCode} AND gender = '2' AND birthdate = ]]> DATE_SUB(CURDATE(),interval 10 YEAR) AND birthdate DATE_SUB(CURDATE(),interval 1 YEAR) AND dog_state = '0' AND business_ban = '0' AND del_flag = '0' GROUP BY dog_breed ORDER BY COUNT(dog_breed) DESC SELECT dog_breed FROM dog WHERE member_code = #{memberCode} AND del_flag = '0' GROUP BY dog_breed ORDER BY COUNT(dog_breed) DESC SELECT , b.id AS "studDogId" FROM dog a LEFT JOIN breeder_stud_dog b ON a.id = b.dog_id AND b.del_flag = '0' WHERE a.member_code = #{memberCode} AND a.dog_breed = #{dogBreed} AND a.gender = '1' AND a.birthdate = ]]> DATE_SUB(CURDATE(),interval 10 YEAR) AND a.birthdate DATE_SUB(CURDATE(),interval 1 YEAR) AND a.dog_state = '0' AND a.business_ban = '0' AND a.del_flag = '0' AND a.id NOT IN( SELECT dog_id FROM breeder_stud_dog WHERE member_code = #{memberCode} AND del_flag = '0' ) ORDER BY a.birthdate ASC LIMIT #{pageNo},#{pageSize} SELECT COUNT(1) FROM dog a WHERE a.member_code = #{memberCode} AND a.dog_breed = #{dogBreed} AND a.gender = '1' AND a.birthdate = ]]> DATE_SUB(CURDATE(),interval 10 YEAR) AND a.birthdate DATE_SUB(CURDATE(),interval 1 YEAR) AND a.dog_state = '0' AND a.business_ban = '0' AND a.del_flag = '0' AND a.id NOT IN( SELECT dog_id FROM breeder_stud_dog WHERE member_code = #{memberCode} AND del_flag = '0' ) SELECT FROM dog a WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND a.id NOT IN( SELECT dog_id FROM breeder_stud_dog WHERE member_code = #{memberCode} AND del_flag = '0' ) ORDER BY a.gender ASC,a.birthdate DESC LIMIT #{pageNo},#{pageSize} SELECT COUNT(1) FROM dog a WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND a.id NOT IN( SELECT dog_id FROM breeder_stud_dog WHERE member_code = #{memberCode} AND del_flag = '0' ) SELECT , b.id AS "studDogId", b.state AS "studDogState", b.cover_img_id AS "studDogCoverImgId" FROM dog a LEFT JOIN breeder_stud_dog b ON a.id = b.dog_id AND b.del_flag = '0' WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND a.id NOT IN( SELECT dog_id FROM breeder_sold_dog WHERE member_code = #{memberCode} ) AND (a.pedigree_certified_code like concat('%',#{searchKey},'%') or a.name_en like concat('%',#{searchKey},'%') or a.call_name like concat('%',#{searchKey},'%') ) ORDER BY a.dog_breed,a.gender ASC,a.birthdate DESC LIMIT #{pageNo},#{pageSize} SELECT COUNT(1) FROM dog a WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND a.id NOT IN( SELECT dog_id FROM breeder_sold_dog WHERE member_code = #{memberCode} AND (a.pedigree_certified_code like concat('%',#{searchKey},'%') or a.name_en like concat('%',#{searchKey},'%') or a.call_name like concat('%',#{searchKey},'%') ) ) SELECT , b.id AS "studDogId", b.state AS "studDogState", b.cover_img_id AS "studDogCoverImgId" FROM dog a LEFT JOIN breeder_stud_dog b ON a.id = b.dog_id AND b.del_flag = '0' WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND a.id IN( SELECT dog_id FROM breeder_sold_dog WHERE member_code = #{memberCode} ) AND (a.pedigree_certified_code like concat('%',#{searchKey},'%') or a.name_en like concat('%',#{searchKey},'%') or a.call_name like concat('%',#{searchKey},'%') ) ORDER BY a.dog_breed,a.gender ASC,a.birthdate DESC LIMIT #{pageNo},#{pageSize} SELECT COUNT(1) FROM dog a WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND a.id IN( SELECT dog_id FROM breeder_sold_dog WHERE member_code = #{memberCode} ) AND (a.pedigree_certified_code like concat('%',#{searchKey},'%') or a.name_en like concat('%',#{searchKey},'%') or a.call_name like concat('%',#{searchKey},'%') ) SELECT , b.id AS "studDogId", b.state AS "studDogState", b.cover_img_id AS "studDogCoverImgId" FROM dog a LEFT JOIN breeder_stud_dog b ON a.id = b.dog_id AND b.del_flag = '0' WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND (a.pedigree_certified_code like concat('%',#{searchKey},'%') or a.name_en like concat('%',#{searchKey},'%') or a.call_name like concat('%',#{searchKey},'%') ) ORDER BY a.dog_breed,a.gender ASC,a.birthdate DESC LIMIT #{pageNo},#{pageSize} SELECT COUNT(1) FROM dog a WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND (a.pedigree_certified_code like concat('%',#{searchKey},'%') or a.name_en like concat('%',#{searchKey},'%') or a.call_name like concat('%',#{searchKey},'%') ) INSERT INTO breeder_sold_dog( dog_id, member_code ) VALUES ( #{dogId}, #{memberCode} ) DELETE FROM breeder_sold_dog WHERE dog_id = #{dogId} AND member_code = #{memberCode} SELECT FROM dog a LEFT JOIN breeder_stud_dog b ON a.id = b.dog_id WHERE a.member_code = #{memberCode} AND a.gender = #{gender} AND ( a.pedigree_certified_code LIKE CONCAT('%',#{key},'%') OR a.identification_flag LIKE CONCAT('%',#{key},'%') OR a.nickname LIKE CONCAT('%',#{key},'%') ) AND a.birthdate = ]]> DATE_SUB(CURDATE(),interval 10 YEAR) AND a.birthdate = ]]> DATE_SUB(CURDATE(),interval 8 YEAR) AND a.pedigree_certified_code not like "%CKUHK%" AND a.birthdate DATE_SUB(CURDATE(),interval 1 YEAR) AND a.dog_state = '0' AND a.business_ban = '0' AND a.del_flag = '0' AND (b.del_flag = '0' OR b.del_flag IS NULL) AND LEFT(a.pedigree_certified_code,3) = 'CKU' ORDER BY b.state DESC, a.birthdate DESC LIMIT #{pageNo},#{pageSize} SELECT COUNT(1) FROM dog a LEFT JOIN breeder_stud_dog b ON a.id = b.dog_id WHERE a.member_code = #{memberCode} AND a.gender = #{gender} AND ( a.pedigree_certified_code LIKE CONCAT('%',#{key},'%') OR a.identification_flag LIKE CONCAT('%',#{key},'%') OR a.nickname LIKE CONCAT('%',#{key},'%') ) AND a.birthdate = ]]> DATE_SUB(CURDATE(),interval 10 YEAR) AND a.birthdate = ]]> DATE_SUB(CURDATE(),interval 8 YEAR) AND a.birthdate DATE_SUB(CURDATE(),interval 1 YEAR) AND a.dog_state = '0' AND a.business_ban = '0' AND a.del_flag = '0' AND (b.del_flag = '0' OR b.del_flag IS NULL) AND LEFT(a.pedigree_certified_code,3) = 'CKU' SELECT , b.cover_img_id AS "studDogCoverImgId" FROM ( SELECT s.pedigree_certified, MAX(s.create_date) AS create_date FROM show_apply s WHERE ( s.payment_member_code = #{memberCode} OR (s.handler_member_code = #{memberCode} OR s.handler_member_code LIKE CONCAT(#{memberCode},',%')) OR s.dog_owner_member_code = #{memberCode} ) GROUP BY s.pedigree_certified ) s LEFT JOIN dog a ON s.pedigree_certified = a.pedigree_certified_code LEFT JOIN breeder_stud_dog b ON a.id = b.dog_id WHERE a.del_flag = '0' AND a.dog_state IN ('0','5') AND a.business_ban = '0' ORDER BY s.create_date DESC LIMIT #{pageNo},#{pageSize} SELECT COUNT(1) FROM ( SELECT s.pedigree_certified, MAX(s.create_date) AS create_date FROM show_apply s WHERE ( s.payment_member_code = #{memberCode} OR s.handler_member_code LIKE CONCAT(#{memberCode},'%') OR s.dog_owner_member_code = #{memberCode} ) GROUP BY s.pedigree_certified ) s LEFT JOIN dog a ON s.pedigree_certified = a.pedigree_certified_code WHERE a.del_flag = '0' AND a.dog_state IN ('0','5') AND a.business_ban = '0' SELECT a.id AS "id", a.logout AS "logout", a.identification_flag AS "identificationFlag", a.pedigree_certified_code AS "pedigreeCertifiedCode", a.dog_owner AS "dogOwner", a.member_code AS "memberCode", a.breeder AS "breeder", a.name_cn AS "nameCn", a.name_en AS "nameEn", a.nickname AS "callName", a.gender AS "gender", a.dog_breed AS "dogBreed", a.birthdate AS "birthdate", a.wool AS "wool", b.dog_color_mark_cn AS "colorFlag" FROM dog a LEFT JOIN dog_color_mark b ON b.dog_color_mark_code = a.color_flag WHERE a.identification_flag = #{_parameter} AND a.del_flag = '0' update dog set business_ban = #{businessBan} where id = #{id} update dog set gold_certified_type = #{goldCertifiedType}, gold_certified_state = #{goldCertifiedState}, print_state = #{printState}, update_by = #{updateBy.id}, update_date = #{updateDate} where id = #{id} SELECT FROM dog a WHERE a.del_flag = "0" and (a.identification_flag = #{keyword} or a.pedigree_certified_code = #{keyword}) limit 1; select cover_img_id as coverImgId from breeder_stud_dog where dog_id = #{id} and del_flag='0' select from dog a where a.birth_certificate_level_code=#{birthCertificateLevelCode} and a.del_flag='0' SELECT , b.member_site AS "dogOwnerSite" FROM dog a LEFT JOIN sys_member b ON a.member_code = b.member_code WHERE (a.pedigree_certified_code =#{key} or a.identification_flag = #{key}) and a.del_flag='0' ORDER BY FIELD(LEFT(a.pedigree_certified_code, 3),'CKU') DESC LIMIT 1 SELECT dog_owner as "nameCn" , birth_certificate_level_code as "birthCertificateLevelCode" FROM dog a WHERE a.del_flag = '0' AND a.birth_certificate_level_code IN #{item} SELECT dog_owner as "nameCn", pedigree_certified_code as "pedigreeCertifiedCode" FROM dog a WHERE a.del_flag = '0' AND a.pedigree_certified_code IN #{item} select count(*) from dog where del_flag='0' and picture_review_state='0' SELECT , b.member_site AS "dogOwnerSite" FROM dog a LEFT JOIN sys_member b ON a.member_code = b.member_code WHERE a.del_flag='0' and picture_review_state=#{pictureReviewState} and picture_review_state='0' select id, birth_certificate_level_code, pedigree_certified_code, dog_owner, member_code, print_state, dog_state from dog where birth_certificate_level_code=#{birthCertificateLevelCode} and del_flag='0' SELECT , b.member_site AS "dogOwnerSite" FROM dog a LEFT JOIN sys_member b ON a.member_code = b.member_code WHERE 1=1 and a.pedigree_certified_code =#{pedigreeCertifiedCode} and a.identification_flag = #{identificationFlag} SELECT * FROM dog a WHERE a.del_flag = '0' AND a.pedigree_certified_code IN #{item}