Searchable Judges Directory

pr_judge_search - query

RESULTSET

pr_judge_search - query
	CDE_COUNTRY	CDE_POSTAL_CODE	CDE_STATE_PROVINCE	CDE_VISITING_JUDGE	DESC_JUDGE_STATUS	DESC_STATE_PROVINCE	IND_IS_DELEGATE	KEYFIELD	NUM_JUDGE	SEARCH_NAME_FIRST	SEARCH_NAME_LAST	TEXT_ADDR1	TEXT_ADDR2	TEXT_CITY	TEXT_E_MAIL1	TEXT_JUDGE_FEE_INFO	TEXT_JUDGE_URL	TEXT_NAME_FIRST	TEXT_NAME_LAST_OR_OTHER	TEXT_NAME_MIDDLE	TEXT_PREFIX	TEXT_SUFFIX
1	USA	80302-9245	CO	[empty string]	[empty string]	Colorado	N	11825624	92234	CHRISTINE	MANN	2942 Sugarloaf Rd	[empty string]	Boulder	bluemoonbmd@earthlink.net	[empty string]	[empty string]	Christine	Mann	C	Ms.	[empty string]

CACHED

false

EXECUTIONTIME

SQL

-- pr_judge_search 2 SELECT distinct(judge.key_stkhldr_judge) as keyfield ,judge.search_name_last ,judge.search_name_first ,judge.text_name_last_or_other ,judge.text_name_first ,judge.text_name_middle ,judge.desc_judge_status ,judge.num_judge ,judge.cde_visiting_judge ,judge.text_prefix ,judge.text_suffix ,judge.text_e_mail1 ,addr.text_addr1 , addr.text_addr2 , addr.text_city , addr.cde_postal_code , addr.cde_state_province , addr.cde_country , state.desc_state_province , judge.text_judge_url , text_judge_fee_info ,( case when exists ( select 'x' from akc.t_club_role_relation_akc crr where crr.key_stkhldr_secondary = judge.key_stkhldr_judge and crr.cde_role_type = 'DELGTE' and sysdate between crr.date_effective and crr.date_end ) then 'Y' else 'N' end ) as ind_is_delegate FROM akc.t_judge_directory_web judge, akc.t_judges_dir_address_web addr, akc.t_judges_directory_breeds_web breed, akc.t_cde_state_province_web state WHERE judge.key_stkhldr_judge = addr.key_stkhldr_judge AND judge.key_stkhldr_judge = breed.key_stkhldr_judge (+) AND RTrim(state.cde_state_province) = RTrim(addr.cde_state_province) AND judge.num_judge = ? AND RTrim(addr.cde_state_province) in ( SELECT RTrim(cde_state_province) FROM akc.t_cde_state_province_web state ) ORDER BY desc_state_province, search_name_last,search_name_first

SQLPARAMETERS

pr_judge_search - array
1	92234

Please notify the AKC If any of the information within this directory is believed to be inaccurate or out of date. To assist we ask that the information is forwarded to the appropriate department: Agility, Conformation, Obedience, Rally, Tracking, Performance. *Indicates Delegate Judge

Results Found for Colorado

Ms. Christine C Mann

Click here for Group/Breed Detail Dates

Judge's Number: 92234

Judge Type: Conformation

Address:

2942 Sugarloaf Rd
Boulder, CO 80302-9245

Home Telephone:

(303) 443-2837

Email:

bluemoonbmd@earthlink.net

Initial Breed: Bernese Mountain Dogs

Breed/Group/Class	Status
Alaskan Malamutes	Prov/Permit
Bernese Mountain Dogs	Approved
Greater Swiss Mountain Dogs	Prov/Permit
Newfoundlands	Prov/Permit

Click here for Past Judging Assignments
Click here for Future Judging Assignments

New Search: Name | Conformation | Junior Showmanship | Agility/Obedience/Tracking/Rally | Performance

Breed Explorer

Choosing The Right Breed

Prospective Owners

Additional Resources

Featured

Browse By Topic

Tools & Quizzes

Additional Resources

Products

Services

Featured Products

Shop The AKC Store

GETTING STARTED IN DOG SPORTS

Featured Events

Browse All Dog Sports

RESOURCES FOR DOG SPORT PARTICIPANTS

Find a Club

Clubs Offering:

Clubs

For Delegates

Government Relations

AKC Library & Archives

Searchable Judges Directory

Results Found for Colorado

ABOUT AKC +

Top Services +

Top Resources +

Get Involved +

Favorite Things +