AKC Judges Search and 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_E_MAIL2	TEXT_E_MAIL3	TEXT_JUDGE_FEE_INFO	TEXT_JUDGE_URL	TEXT_NAME_FIRST	TEXT_NAME_LAST_OR_OTHER	TEXT_NAME_MIDDLE	TEXT_PREFIX	TEXT_SUFFIX
1	USA	37065	TN	[empty string]	[empty string]	Tennessee	Y	10044614	18846	DAVID	HADDOCK	PO BOX 5	[empty string]	FRANKLIN	globalfone@aol.com	[empty string]	[empty string]	[empty string]	[empty string]	David	Haddock	W	Mr.	[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 ,judge.text_e_mail2 ,judge.text_e_mail3 ,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	18846

Mr. David W Haddock

Judge's Number: 18846 Judge Type: Conformation, Junior Showmanship, Obedience, Rally

Address:

PO BOX 5, FRANKLIN, TN 37065

CEL Telephone:

(615) 430-4773

Email(s):

globalfone@aol.com

Initial Breed: Portuguese Water Dogs

CONF

	Breed/Group/Class	Status

	Sporting Group	( Appr.* Dec, 01 2020 Prov/Permit Feb, 07 2019)*
	Barbets	( Appr.* Dec, 01 2020 Prov/Permit May, 15 2019)*
	Brittanys	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Lagotti Romagnoli	( Appr.* Jan, 31 2020 Prov/Permit Feb, 07 2019)*
	Nederlandse Kooikerhondjes	( Appr.* Dec, 01 2020 Prov/Permit Feb, 07 2019)*
	Pointers	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Pointers (German Shorthaired)	( Appr.* Aug, 15 2018 Prov/Permit Jul, 06 2017)*
	Pointers (German Wirehaired)	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Retrievers (Chesapeake Bay)	( Appr.* Aug, 15 2018 Prov/Permit Jul, 06 2017)*
	Retrievers (Curly-Coated)	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Retrievers (Flat-Coated)	( Appr.* Jan, 31 2020 Prov/Permit Feb, 07 2019)*
	Retrievers (Golden)	( Appr.* Aug, 15 2018 Prov/Permit Jul, 06 2017)*
	Retrievers (Labrador)	( Appr.* Aug, 15 2018 Prov/Permit Jul, 06 2017)*
	Retrievers (Nova Scotia Duck Tolling)	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Setters (English)	( Appr.* Aug, 15 2018 Prov/Permit Jul, 06 2017)*
	Setters (Gordon)	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Setters (Irish)	( Appr.* Nov, 01 2017 Prov/Permit Apr, 06 2017)*
	Setters (Irish Red and White)	( Appr.* Aug, 15 2018 Prov/Permit Jul, 06 2017)*
	Spaniels (American Water)	( Appr.* Dec, 01 2020 Prov/Permit Feb, 07 2019)*
	Spaniels (Boykin)	( Appr.* Dec, 01 2020 Prov/Permit Feb, 07 2019)*
	Spaniels (Clumber)	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Spaniels (Cocker)	( Appr.* Aug, 15 2018 Prov/Permit Jul, 06 2017)*
	Spaniels (English Cocker)	( Appr.* Jan, 31 2020 Prov/Permit Feb, 07 2019)*
	Spaniels (English Springer)	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Spaniels (Field)	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Spaniels (Irish Water)	( Appr.* Aug, 15 2018 Prov/Permit Jul, 06 2017)*
	Spaniels (Sussex)	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Spaniels (Welsh Springer)	( Appr.* Sep, 04 2018 Prov/Permit Jul, 06 2017)*
	Spinoni Italiani	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Vizslas	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Weimaraners	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Wirehaired Pointing Griffons	( Appr.* Aug, 15 2018 Prov/Permit Apr, 06 2017)*
	Wirehaired Vizslas	( Appr.* Mar, 02 2020 Prov/Permit Feb, 07 2019)*

	Dachshunds	( Appr.* Jan, 31 2020 Prov/Permit Feb, 07 2019)*
	Grand Basset Griffon Vendeens	( Appr.* Jan, 31 2020 Prov/Permit Feb, 07 2019)*
	Petits Bassets Griffons Vendeens	( Appr.* Mar, 15 2021 Prov/Permit Feb, 07 2019)*

	Working Group	( Appr.* Nov, 17 2015 Prov/Permit Oct, 15 2014)*
	Akitas	( Appr.* Apr, 29 2011 Prov/Permit Mar, 01 2010)*
	Alaskan Malamutes	( Appr.* Jun, 10 2008 Prov/Permit Aug, 01 2007)*
	Anatolian Shepherd Dogs	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*
	Bernese Mountain Dogs	( Appr.* Apr, 29 2011 Prov/Permit Mar, 01 2010)*
	Black Russian Terriers	( Appr.* Nov, 17 2015 Prov/Permit Oct, 15 2014)*
	Boerboels	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*
	Boxers	( Appr.* Apr, 29 2011 Prov/Permit Mar, 01 2010)*
	Bullmastiffs	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Cane Corso	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*
	Chinooks	( Appr.* Nov, 17 2015 Prov/Permit Oct, 15 2014)*
	Doberman Pinschers	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Dogo Argentinos	( Appr.* May, 15 2019)*
	Dogues de Bordeaux	( Appr.* Sep, 15 2015 Prov/Permit Oct, 15 2014)*
	German Pinschers	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*
	Giant Schnauzers	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Great Danes	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Great Pyrenees	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Greater Swiss Mountain Dogs	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*
	Komondorok	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*
	Kuvaszok	( Appr.* Apr, 29 2011 Prov/Permit Mar, 01 2010)*
	Leonbergers	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*
	Mastiffs	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Neapolitan Mastiffs	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*
	Newfoundlands	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Portuguese Water Dogs	( Appr.* Apr, 10 2007 Prov/Permit Feb, 01 2006)*
	Rottweilers	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	St. Bernards	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Samoyeds	( Appr.* Oct, 13 2009 Prov/Permit Oct, 01 2008)*
	Siberian Huskies	( Appr.* Oct, 13 2009 Prov/Permit Oct, 01 2008)*
	Standard Schnauzers	( Appr.* Sep, 17 2012 Prov/Permit Nov, 14 2011)*
	Tibetan Mastiffs	( Appr.* Oct, 01 2015 Prov/Permit Oct, 15 2014)*

	Australian Cattle Dogs	( Appr.* Jan, 31 2020 Prov/Permit Feb, 07 2019)*
	Australian Shepherds	( Appr.* Jan, 31 2020 Prov/Permit Feb, 07 2019)*
	Bearded Collies	( Prov/Permit* Sep, 03 2020)*
	Belgian Malinois	( Prov/Permit* Sep, 03 2020)*
	Belgian Sheepdogs	( Prov/Permit* Sep, 03 2020)*
	Belgian Tervuren	( Prov/Permit* Sep, 03 2020)*
	Bergamasco Sheepdogs	( Prov/Permit* Sep, 03 2020)*
	Berger Picards	( Prov/Permit* Sep, 03 2020)*
	Border Collies	( Prov/Permit* Nov, 07 2019)*
	Bouviers des Flandres	( Prov/Permit* Sep, 03 2020)*
	Briards	( Prov/Permit* Nov, 07 2019)*
	Canaan Dogs	( Prov/Permit* Sep, 03 2020)*
	Cardigan Welsh Corgis	( Prov/Permit* Sep, 03 2020)*
	Old English Sheepdogs	( Prov/Permit* Nov, 07 2019)*
	Pembroke Welsh Corgis	( Prov/Permit* Nov, 07 2019)*
	Pulik	( Prov/Permit* Sep, 03 2020)*
	Shetland Sheepdogs	( Prov/Permit* Nov, 07 2019)*
	Spanish Water Dogs	( Prov/Permit* Nov, 07 2019)*

	Best In Show	( Appr.* Dec, 01 2015)*

	Conformation - Misc Breeds	( Appr.* Nov, 17 2015)*

	Junior Showmanship - Limited Breeds	Prov/Permit








	Obedience Novice	Approved - Apr, 22 2002
	Obedience Open	Approved - Feb, 11 2003
	Obedience Utility	Approved - Apr, 13 2004
	Obedience - Non-Reg Classes	Approved - Apr, 22 2002

	Rally - Non-Reg Classes	Approved - Oct, 31 2007
	Rally Novice	Approved - Feb, 02 2006
	Rally Intermediate	Approved - Jun, 21 2017
	Rally Advanced	Approved - Feb, 02 2006
	Rally Master	Approved - Jun, 21 2017
	Rally Excellent	Approved - Feb, 02 2006

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

AKC Judges Search and Directory

ABOUT AKC +

Top Services +

Top Resources +

Get Involved +

Favorite Things +