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_JUDGE_FEE_INFO	TEXT_JUDGE_URL	TEXT_NAME_FIRST	TEXT_NAME_LAST_OR_OTHER	TEXT_NAME_MIDDLE	TEXT_PREFIX	TEXT_SUFFIX
1	USA	97007-2110	OR	[empty string]	[empty string]	Oregon	N	12870542	5928	PATRICIA (PAT)	HASTINGS	17195 SW DIVISION ST	[empty string]	ALOHA	pat@dogfolk.com	[empty string]	[empty string]	Patricia (Pat)	Hastings	[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 ,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	5928


Mrs. Patricia (Pat) Hastings
Judge's Number: 5928 Judge Type: Conformation, Junior Showmanship
Address:	17195 SW DIVISION ST, ALOHA, OR 97007-2110
Home Telephone:	(503) 642-3585
Fax Telephone:	(503) 642-3585
CEL Telephone:	(503) 706-7081
Email:	pat@dogfolk.com
Initial Breed: Poodles

CONF

	Breed/Group/Class	Status

	Afghan Hounds	( Prov/Permit* Jan, 07 2020)*
	Basenjis	( Prov/Permit* Jan, 07 2020)*
	Basset Hounds	( Prov/Permit* Jan, 07 2020)*
	Beagles	( Prov/Permit* Jan, 07 2020)*
	Cirnechi dell'Etna	( Prov/Permit* Jan, 07 2020)*
	Dachshunds	( Prov/Permit* Jan, 07 2020)*
	Greyhounds	( Prov/Permit* Jan, 07 2020)*
	Harriers	( Prov/Permit* Jan, 07 2020)*
	Irish Wolfhounds	( Prov/Permit* Jan, 07 2020)*
	Norwegian Elkhounds	( Prov/Permit* Jan, 07 2020)*
	Rhodesian Ridgebacks	( Prov/Permit* Jan, 07 2020)*
	Whippets	( Prov/Permit* Jan, 07 2020)*

	Working Group	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Akitas	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Alaskan Malamutes	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Anatolian Shepherd Dogs	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Bernese Mountain Dogs	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Black Russian Terriers	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Boerboels	( Appr.* Apr, 24 2014)*
	Boxers	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Bullmastiffs	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Cane Corso	( Appr.* Jan, 04 2010)*
	Chinooks	( Appr.* Jul, 02 2012)*
	Doberman Pinschers	( Appr.* Nov, 01 1993)*
	Dogo Argentinos	( Appr.* May, 15 2019)*
	Dogues de Bordeaux	( Appr.* Feb, 01 2008)*
	German Pinschers	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Giant Schnauzers	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Great Danes	( Appr.* Nov, 01 1993)*
	Great Pyrenees	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Greater Swiss Mountain Dogs	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Komondorok	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Kuvaszok	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Leonbergers	( Appr.* Jan, 04 2010)*
	Mastiffs	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Neapolitan Mastiffs	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Newfoundlands	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Portuguese Water Dogs	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Rottweilers	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	St. Bernards	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Samoyeds	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Siberian Huskies	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Standard Schnauzers	( Appr.* Dec, 13 2005 Prov/Permit Oct, 01 2004)*
	Tibetan Mastiffs	( Appr.* Jan, 01 2007)*

	Terrier Group	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Airedale Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	American Hairless Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 01 2015)*
	American Staffordshire Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Australian Terriers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Bedlington Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Border Terriers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Bull Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Cairn Terriers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Cesky Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Dandie Dinmont Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Fox Terriers (Smooth)	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Fox Terriers (Wire)	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Glen of Imaal Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Irish Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Kerry Blue Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Lakeland Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Manchester Terriers (Standard)	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Miniature Bull Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Miniature Schnauzers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Norfolk Terriers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Norwich Terriers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Parson Russell Terriers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Rat Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Russell Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Scottish Terriers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Sealyham Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Skye Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Soft Coated Wheaten Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Staffordshire Bull Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	Welsh Terriers	( Appr.* Sep, 30 2013 Prov/Permit Feb, 01 2011)*
	West Highland White Terriers	( Appr.* Jan, 13 2009 Prov/Permit May, 01 2007)*
	Manchester Terriers	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*

	Toy Group	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Affenpinschers	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Brussels Griffons	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Cavalier King Charles Spaniels	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Chihuahuas	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Chinese Crested	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	English Toy Spaniels	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Havanese	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Italian Greyhounds	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Japanese Chin	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Maltese	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Manchester Terriers (Toy)	( Appr.* Jul, 31 2015 Prov/Permit May, 15 2014)*
	Miniature Pinschers	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Papillons	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Pekingese	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Pomeranians	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Poodles (Toy)	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Pugs	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Shih Tzu	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Silky Terriers	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Toy Fox Terriers	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*
	Yorkshire Terriers	( Appr.* Jun, 01 2017 Prov/Permit May, 05 2016)*

	Non-Sporting Group	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	American Eskimo Dogs	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Bichons Frises	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Boston Terriers	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Bulldogs	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Chinese Shar-Pei	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Chow Chows	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Coton de Tulear	( Appr.* Jan, 06 2014)*
	Dalmatians	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Finnish Spitz	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	French Bulldogs	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Keeshonden	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Lhasa Apsos	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Lowchen	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Norwegian Lundehunds	( Appr.* Dec, 21 2010)*
	Poodles	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Schipperkes	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Shiba Inu	( Appr.* Jul, 01 1996)*
	Tibetan Spaniels	( Appr.* Nov, 12 2003 Prov/Permit Aug, 30 2001)*
	Tibetan Terriers	( Appr.* Sep, 08 2000 Prov/Permit Feb, 01 1998)*
	Xoloitzcuintli	( Appr.* Dec, 21 2010)*

	Herding Group	( Appr.* Jul, 01 1996)*
	Australian Cattle Dogs	( Appr.* Jul, 01 1996)*
	Australian Shepherds	( Appr.* Jul, 01 1996)*
	Bearded Collies	( Appr.* Nov, 01 1993)*
	Beaucerons	( Appr.* Jun, 27 2007)*
	Belgian Laekenois	( Appr.* Feb, 01 2020)*
	Belgian Malinois	( Appr.* Nov, 01 1993)*
	Belgian Sheepdogs	( Appr.* Nov, 01 1993)*
	Belgian Tervuren	( Appr.* Nov, 01 1993)*
	Bergamasco Sheepdogs	( Appr.* Apr, 24 2014)*
	Berger Picards	( Appr.* Nov, 03 2014)*
	Border Collies	( Appr.* Mar, 01 1995)*
	Bouviers des Flandres	( Appr.* Nov, 01 1993)*
	Briards	( Appr.* Nov, 01 1993)*
	Canaan Dogs	( Appr.* Aug, 01 1997)*
	Cardigan Welsh Corgis	( Appr.* Jul, 01 1996)*
	Collies	( Appr.* Nov, 01 1993)*
	Entlebucher Mountain Dogs	( Appr.* Dec, 21 2010)*
	Finnish Lapphunds	( Appr.* Jan, 17 2011)*
	German Shepherd Dogs	( Appr.* Jul, 01 1996)*
	Icelandic Sheepdogs	( Appr.* Jan, 04 2010)*
	Miniature American Shepherds	( Appr.* Nov, 03 2014)*
	Norwegian Buhunds	( Appr.* Jul, 01 2008)*
	Old English Sheepdogs	( Appr.* Nov, 01 1993)*
	Pembroke Welsh Corgis	( Appr.* Jul, 01 1996)*
	Polish Lowland Sheepdogs	( Appr.* Feb, 21 2001)*
	Pulik	( Appr.* Nov, 01 1993)*
	Pumik	( Appr.* Nov, 30 2015)*
	Pyrenean Shepherds	( Appr.* Jul, 01 2008)*
	Shetland Sheepdogs	( Appr.* Jul, 01 1996)*
	Spanish Water Dogs	( Appr.* Apr, 24 2014)*
	Swedish Vallhunds	( Appr.* Jun, 27 2007)*

	Best In Show	( Appr.* Sep, 01 1996)*

	Conformation - Misc Breeds	( Appr.* Nov, 12 2003)*

	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 +