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	CAN	V2K 4A3	BC	[empty string]	[empty string]	British Columbia	N	12876500	6773	HONEY ANNE	GLENDINNING	2695 RIDGEVIEW DRIVE	[empty string]	PRINCE GEORGE	honeyanneg@icloud.com	[empty string]	[empty string]	[empty string]	[empty string]	Honey Anne	Glendinning	[empty string]	Mrs.	[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	6773

Mrs. Honey Anne Glendinning

Judge's Number: 6773 Judge Type: Conformation, Junior Showmanship

Address:

2695 RIDGEVIEW DRIVE, PRINCE GEORGE, BC V2K 4A3

Home Telephone:

(604) 943-4313

Email(s):

honeyanneg@icloud.com

CONF

	Breed/Group/Class	Status

	Sporting Group	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Barbets	( Appr.* May, 15 2019)*
	Brittanys	( Appr.* Oct, 13 1999 Prov/Permit Feb, 01 1996)*
	Lagotti Romagnoli	( Appr.* Nov, 03 2014)*
	Nederlandse Kooikerhondjes	( Appr.* May, 01 2017)*
	Pointers	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Pointers (German Shorthaired)	( Appr.* Oct, 13 1999 Prov/Permit Feb, 01 1996)*
	Pointers (German Wirehaired)	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Retrievers (Chesapeake Bay)	( Appr.* Aug, 10 2004 Prov/Permit Aug, 07 2000)*
	Retrievers (Curly-Coated)	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Retrievers (Flat-Coated)	( Appr.* Aug, 10 2004 Prov/Permit Aug, 07 2000)*
	Retrievers (Golden)	( Appr.* Oct, 13 1999 Prov/Permit Feb, 01 1996)*
	Retrievers (Labrador)	( Appr.* Oct, 13 1999 Prov/Permit Feb, 01 1996)*
	Retrievers (Nova Scotia Duck Tolling)	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Setters (English)	( Appr.* Oct, 13 1999 Prov/Permit Feb, 01 1996)*
	Setters (Gordon)	( Appr.* Oct, 13 1999 Prov/Permit Feb, 01 1996)*
	Setters (Irish)	( Appr.* Oct, 13 1999 Prov/Permit Feb, 01 1996)*
	Setters (Irish Red and White)	( Appr.* Jul, 01 2008)*
	Spaniels (American Water)	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Spaniels (Boykin)	( Appr.* Jul, 01 2009)*
	Spaniels (Clumber)	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Spaniels (Cocker)	( Appr.* Aug, 10 2004 Prov/Permit Aug, 07 2000)*
	Spaniels (English Cocker)	( Appr.* Aug, 10 2004 Prov/Permit Aug, 07 2000)*
	Spaniels (English Springer)	( Appr.* Aug, 10 2004 Prov/Permit Aug, 07 2000)*
	Spaniels (Field)	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Spaniels (Irish Water)	( Appr.* Aug, 10 2004 Prov/Permit Aug, 07 2000)*
	Spaniels (Sussex)	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Spaniels (Welsh Springer)	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Spinoni Italiani	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Vizslas	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Weimaraners	( Appr.* Aug, 10 2004 Prov/Permit Aug, 07 2000)*
	Wirehaired Pointing Griffons	( Appr.* Mar, 12 2008 Prov/Permit Jul, 03 2006)*
	Wirehaired Vizslas	( Appr.* Jan, 06 2014)*

	Bloodhounds	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Dachshunds	( Prov/Permit* Jul, 07 2016)*
	Irish Wolfhounds	( Appr.* Feb, 16 2015 Prov/Permit Oct, 11 2013)*

	Working Group	( Prov/Permit* Jul, 07 2016)*
	Akitas	( Prov/Permit* Jul, 07 2016)*
	Alaskan Malamutes	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Anatolian Shepherd Dogs	( Prov/Permit* Feb, 02 2016)*
	Bernese Mountain Dogs	( Appr.* Sep, 15 2014 Prov/Permit Oct, 11 2013)*
	Black Russian Terriers	( Prov/Permit* Feb, 02 2016)*
	Boerboels	( Prov/Permit* Jul, 07 2016)*
	Boxers	( Appr.* Jul, 01 2016 Prov/Permit Jul, 16 2015)*
	Bullmastiffs	( Appr.* Jun, 01 2016 Prov/Permit Jul, 16 2015)*
	Cane Corso	( Appr.* Dec, 02 2011 Prov/Permit Jul, 01 2010)*
	Chinooks	( Appr.* Mar, 16 2015 Prov/Permit Oct, 11 2013)*
	Doberman Pinschers	( Appr.* Jun, 01 2016 Prov/Permit Jul, 16 2015)*
	Dogo Argentinos	( Prov/Permit* May, 15 2019)*
	Dogues de Bordeaux	( Appr.* Oct, 01 2010 Prov/Permit Jun, 02 2008)*
	German Pinschers	( Prov/Permit* Feb, 02 2016)*
	Giant Schnauzers	( Prov/Permit* Jul, 07 2016)*
	Great Danes	( Appr.* Apr, 02 2012 Prov/Permit Mar, 01 2011)*
	Great Pyrenees	( Appr.* Mar, 16 2015 Prov/Permit Oct, 11 2013)*
	Greater Swiss Mountain Dogs	( Appr.* Oct, 03 2016 Prov/Permit Feb, 02 2016)*
	Komondorok	( Prov/Permit* Jul, 07 2016)*
	Kuvaszok	( Prov/Permit* Feb, 02 2016)*
	Leonbergers	( Appr.* Dec, 02 2011 Prov/Permit Jul, 01 2010)*
	Mastiffs	( Appr.* Apr, 02 2012 Prov/Permit Mar, 01 2011)*
	Neapolitan Mastiffs	( Prov/Permit* Jul, 07 2016)*
	Newfoundlands	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Portuguese Water Dogs	( Appr.* Feb, 16 2015 Prov/Permit Oct, 11 2013)*
	Rottweilers	( Prov/Permit* Jul, 07 2016)*
	St. Bernards	( Appr.* Apr, 02 2012 Prov/Permit Mar, 01 2011)*
	Samoyeds	( Appr.* Oct, 03 2016 Prov/Permit Feb, 02 2016)*
	Siberian Huskies	( Appr.* Oct, 03 2016 Prov/Permit Jul, 16 2015)*
	Standard Schnauzers	( Prov/Permit* Feb, 02 2016)*
	Tibetan Mastiffs	( Prov/Permit* Jul, 07 2016)*

	English Toy Spaniels	( Prov/Permit* Jul, 07 2016)*
	Poodles (Toy)	( Prov/Permit* Jul, 07 2016)*

	Bulldogs	( Prov/Permit* Feb, 09 2017)*
	Chow Chows	( Prov/Permit* Feb, 09 2017)*
	Coton de Tulear	( Prov/Permit* Feb, 09 2017)*
	Dalmatians	( Prov/Permit* Feb, 09 2017)*
	Finnish Spitz	( Prov/Permit* Feb, 09 2017)*
	Lhasa Apsos	( Prov/Permit* Feb, 09 2017)*
	Norwegian Lundehunds	( Appr.* Sep, 11 2013 Prov/Permit Jul, 01 2011)*
	Poodles	( Prov/Permit* Jul, 07 2016)*
	Shiba Inu	( Prov/Permit* Feb, 09 2017)*
	Xoloitzcuintli	( Appr.* Sep, 11 2013 Prov/Permit Jul, 01 2011)*

	Herding Group	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Australian Cattle Dogs	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Australian Shepherds	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Bearded Collies	( Appr.* Apr, 02 2012 Prov/Permit Mar, 01 2011)*
	Beaucerons	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Belgian Laekenois	( Appr.* Feb, 01 2020)*
	Belgian Malinois	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Belgian Sheepdogs	( Appr.* Jul, 03 2012 Prov/Permit Mar, 01 2011)*
	Belgian Tervuren	( Appr.* Apr, 02 2012 Prov/Permit Mar, 01 2011)*
	Bergamasco Sheepdogs	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Berger Picards	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Border Collies	( Appr.* Jul, 03 2012 Prov/Permit Mar, 01 2011)*
	Bouviers des Flandres	( Appr.* Sep, 15 2014 Prov/Permit Oct, 11 2013)*
	Briards	( Appr.* Jul, 03 2012 Prov/Permit Mar, 01 2011)*
	Canaan Dogs	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Cardigan Welsh Corgis	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Collies	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Entlebucher Mountain Dogs	( Appr.* Sep, 11 2013 Prov/Permit Jul, 01 2011)*
	Finnish Lapphunds	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	German Shepherd Dogs	( Appr.* Apr, 02 2012 Prov/Permit Mar, 01 2011)*
	Icelandic Sheepdogs	( Appr.* Apr, 02 2012 Prov/Permit Jul, 01 2010)*
	Miniature American Shepherds	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Norwegian Buhunds	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Old English Sheepdogs	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Pembroke Welsh Corgis	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Polish Lowland Sheepdogs	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Pulik	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Pumik	( Appr.* Apr, 01 2016 Prov/Permit Nov, 30 2015)*
	Pyrenean Shepherds	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Shetland Sheepdogs	( Appr.* Oct, 01 2010 Prov/Permit Sep, 02 2008)*
	Spanish Water Dogs	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*
	Swedish Vallhunds	( Appr.* Apr, 01 2016 Prov/Permit Jul, 16 2015)*

	Best In Show	( Appr.* May, 12 2009)*

	Conformation - Misc Breeds	( Appr.* Mar, 12 2008)*

	Junior Showmanship - All Breeds	Approved

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 +