Cairn Terrier Breeders Directory

Find and Contact Fairfield Cairn Terrier Breeders Nearest You Using Our Free Breeder Search Tool Below!

To locate a Cairn Terrier breeder, enter your zip or postal code:

 
 



blog logo

Doggies Blog: Recent Posts

 

 Subscribe to Doggies Blog in RSS Reader

 
 

Fairfield: Cairn Terrier Breeders

Cairn Terrier Puppies Fairfield and Breeders

Below is a sample search of our Cairn Terrier breeders with puppies for sale. The search tool above returns a list of breeders located listings located nearest to the zip or postal code you enter. From there you can see photos of their pups, find out detailed information on their web page and contact them by email, phonoe or even get driving directions.

(Detailed contact information has been omitted Use Enter your zip or postal code above to access our up to date directory).

This is a FREE search tool! Use the form at the top to get complete listings for breeders in your area!


Whites Creek Cairns

Reno, NV 89511

Additional Information: AKC registered in-home raised cairn terrier puppies ~ email for estimated arrival of next litter. Please, see our website for pedigrees and contact info. Little rascals coming soon!!
Services: Puppies,Rescue

Shadow Ridge Ranch

Fall Creek, OR 97438

Additional Information: Available now 10/06/09 one beautiful brindle male puppy ready to go home now! Five gorgeous red males ready to go home 10/24/09. Take a look at these beautuful babies on my site the Available Page.
Services: Puppies,Adult Dogs,Rescue

BRUNS CAIRNS

ROY, WA 98580

Additional Information: I AM A SMALL BREEDER .I HAVE 3-4 LITTERS A YEAR. VERY GOOD BLOOD LINES. 253-843-0165 OR 360-708-9299. ASK FOR CHAR. WILL HAVE PUPS BORN IN DEC. IF YOU'D LIKE TO BE ON LIST CONTACT ME.THANKS
Services: Puppies,Stud Service

Alley Dogs

Clarkston, WA 99403

Additional Information: Small rural Idaho kennel raising quality Cairn Terriers. Our Cairn Terriers are typey, short bodied, short legged, short tails, very correct Cairn Terriers. Our Cairns are hearty, healthy & happy dogs
Services: Puppies

Fenner Kennel

Oro Valley, AZ 85737

Additional Information: Finished Champion male available. Stud services to bitch of merit. possible show bitch available also.
Services: Puppies,Adult Dogs,Stud Service

Shintangle Cairn Terriers

Courtenay, BC V9J1V1

Additional Information: Loving home raised CKC puppies and retired show dogs. Puppies health guaranteed to one year. Both parents can be viewed. Sold with first shots, wormed and vet checked. Guaranteed family friendly.
Services: Puppies,Adult Dogs,Stud Service

Highland Kennel

Big Timber, Mt 59011

Additional Information: All of our 2009 puppies have been sold. Thank you to everyone who purchased one! We are starting a new list for 2010 puppies, so if you want your name added, please call us 406 932-5463 Thank you!
Services: Puppies

B & E Pettiet Kennel

Breckenridge, TX 76424

Additional Information: I have one female and two males available in October 2009. One is almost black just a couple of streaks. For a video of these babies e-mail me bep@cebridge.net
Services: Puppies,Stud Service

T & L Terriers

Axtell, KS 66403

Additional Information: We take pride in raising happy, healthy, sociable AKC Cairn Terriers! A new litter of 2 males arrived and will be ready on July 6. Please call/email for pictures & more information.
Services: Puppies

Susan Hamilton

Bellevue, NE 68123

Additional Information: We currently don't have any puppies available. Chelsea should have another litter around February/March 2010.
Services: Puppies

Kesselcairn

Plattsmouth, NE 68048

Additional Information: Puppies born June 3 & June 6, 2009. AKC registered. Raised as part of our family since birth. Some have show potential.
Services: Puppies

Texas Family Terriers

Granbury, Tx 76048

Additional Information: We have happy healthy puppies! We raise Cairn Terrier and Westies. Our puppies are raised indoors and we have parents on site. One year health guarantee! Shipping is an additional $295
Services: Puppies

Puppy Haven

Rantoul, KS 66079

Additional Information: I don't have any puppies at this time,I will have another litter ready in the spring of 2010.
Services: Puppies,Adult Dogs

Americairn

Granby,, MO 64844

Additional Information: My breedings are made with health, temperment and type in mind. My puppies are raised in our home. I belong to the Cairn Terrier Club of Am. and Tri State Kennel Club. I abide by their code of ethics.
Services: Puppies,Adult Dogs

Wits End Ranch

Grand Saline, TX 75140

Additional Information: Wits End Ranch is a 70 acre airport/children's party ranch where we raise farm animals and beautiful cairn terrier pups. Our pups have champion blood lines www.witsendranch.net
Services: Puppies

Linden Acres

New Richland, MN 56072

Additional Information: Our adult dogs are family pets; pups are raised in our country home & well socialized with kids/animals. Pups come with a 3 yr hlth guar. Puppies born 10/14/09. 3F & 1M. Ready 12/12/09.
Services: Puppies

Kim's Cairns

Chariton, IA 50049

Additional Information: AKC puppies for pets will come in Jan. ready for homes in March. They'll be very healthy, happy little Cairns! Lots of care will go into their well-being. We spend a lot of time with them!
Services: Puppies

Twocando Farm

Ben Wheeler, Tx 75754

Additional Information: Small quality kennel in E Texas. My breeders are AKC, DNA, OFA, and Cerf tested. Championship bloodline. I provide Vet care, cleanliness and personal care for my loving companions and their families.
Services: Puppies,Adult Dogs,Stud Service

Bogan Ranch and Kennels

Newhope, AR 71959

Additional Information: We have puppies available throughout the year. We have farm raised Cairns. All of our puppies are up to date on shots and wormings and dewclaws removed
Services: Puppies,Adult Dogs,Stud Service

SnowedOn Cairns

Esko, MN 55733

Additional Information: Quality show and wonderful pet Cairns bred from generations of OFA health tested Am/Can Champions. We have simply delightful puppies available to loving pet homes now. Email or call for info & pix.
Services: Puppies,Adult Dogs,Stud Service,Rescue

Important: breeders.NET has not screened the listed breeders and accepts no responsibility for their reputation or quality. It is your responsibility to investigate. See How to Find a Dog.

 

Photos, articles and information.

( SELECT 'forum' as type, IF (VP.title != '', VP.title, VT.title) as title, CONCAT('http://www.doggies.com/community/showthread.php?t=', VP.threadid, '#post', VP.postid) as link, FROM_UNIXTIME(VP.dateline) as `date` , '3' as `relevance` FROM `breeders_dbdoggies`.`vbulletin_post` VP, `breeders_dbdoggies`.`vbulletin_thread` VT WHERE VP.threadid = VT.threadid AND ( 0 OR `VP`.`pagetext` LIKE '%Cairn Terrier%' OR `VP`.`title` LIKE '%Cairn Terrier%' ) AND 1 ) UNION ( SELECT 'forum' as type, IF (VP.title != '', VP.title, VT.title) as title, CONCAT('http://www.doggies.com/community/showthread.php?t=', VP.threadid, '#post', VP.postid) as link, FROM_UNIXTIME(VP.dateline) as `date` , '2' as `relevance` FROM `breeders_dbdoggies`.`vbulletin_post` VP, `breeders_dbdoggies`.`vbulletin_thread` VT WHERE VP.threadid = VT.threadid AND ( 1 AND ( 0 OR `VP`.`pagetext` LIKE '%Cairn%' OR `VP`.`title` LIKE '%Cairn%' ) AND ( 0 OR `VP`.`pagetext` LIKE '%Terrier%' OR `VP`.`title` LIKE '%Terrier%' ) ) AND 1 AND VP.`postid` NOT IN ( SELECT VP.`postid` FROM `breeders_dbdoggies`.`vbulletin_post` VP, `breeders_dbdoggies`.`vbulletin_thread` VT WHERE VP.threadid = VT.threadid AND ( 0 OR `VP`.`pagetext` LIKE '%Cairn Terrier%' OR `VP`.`title` LIKE '%Cairn Terrier%' ) AND 1 ) ) UNION ( SELECT 'forum' as type, IF (VP.title != '', VP.title, VT.title) as title, CONCAT('http://www.doggies.com/community/showthread.php?t=', VP.threadid, '#post', VP.postid) as link, FROM_UNIXTIME(VP.dateline) as `date` , '1' as `relevance` FROM `breeders_dbdoggies`.`vbulletin_post` VP, `breeders_dbdoggies`.`vbulletin_thread` VT WHERE VP.threadid = VT.threadid AND ( 0 OR `VP`.`pagetext` LIKE '%Cairn%' OR `VP`.`title` LIKE '%Cairn%' OR `VP`.`pagetext` LIKE '%Terrier%' OR `VP`.`title` LIKE '%Terrier%' ) AND 1 AND VP.`postid` NOT IN ( SELECT VP.`postid` FROM `breeders_dbdoggies`.`vbulletin_post` VP, `breeders_dbdoggies`.`vbulletin_thread` VT WHERE VP.threadid = VT.threadid AND ( 1 AND ( 0 OR `VP`.`pagetext` LIKE '%Cairn%' OR `VP`.`title` LIKE '%Cairn%' ) AND ( 0 OR `VP`.`pagetext` LIKE '%Terrier%' OR `VP`.`title` LIKE '%Terrier%' ) ) AND 1 ) ) UNION ( SELECT 'doggies breed' as type, breeders_dbdoggies.`breeders_dbdoggies`.`doggie_breeds`.breed_name as title, CONCAT('http://www.doggies.com/', URI) as link, NOW() as `date` , '3' as `relevance` FROM `breeders_dbdoggies`.`doggie_breeds` WHERE ( 0 OR `breed_name` LIKE '%Cairn Terrier%' OR `description` LIKE '%Cairn Terrier%' OR `keywords` LIKE '%Cairn Terrier%' OR `caption` LIKE '%Cairn Terrier%' OR `health_concerns` LIKE '%Cairn Terrier%' OR `temperment` LIKE '%Cairn Terrier%' OR `coat` LIKE '%Cairn Terrier%' OR `colors` LIKE '%Cairn Terrier%' OR `weight` LIKE '%Cairn Terrier%' OR `height` LIKE '%Cairn Terrier%' OR `country_of_origin` LIKE '%Cairn Terrier%' OR `living_environment` LIKE '%Cairn Terrier%' ) AND 1 ) UNION ( SELECT 'doggies breed' as type, breeders_dbdoggies.`breeders_dbdoggies`.`doggie_breeds`.breed_name as title, CONCAT('http://www.doggies.com/', URI) as link, NOW() as `date` , '2' as `relevance` FROM `breeders_dbdoggies`.`doggie_breeds` WHERE ( 1 AND ( 0 OR `breed_name` LIKE '%Cairn%' OR `description` LIKE '%Cairn%' OR `keywords` LIKE '%Cairn%' OR `caption` LIKE '%Cairn%' OR `health_concerns` LIKE '%Cairn%' OR `temperment` LIKE '%Cairn%' OR `coat` LIKE '%Cairn%' OR `colors` LIKE '%Cairn%' OR `weight` LIKE '%Cairn%' OR `height` LIKE '%Cairn%' OR `country_of_origin` LIKE '%Cairn%' OR `living_environment` LIKE '%Cairn%' ) AND ( 0 OR `breed_name` LIKE '%Terrier%' OR `description` LIKE '%Terrier%' OR `keywords` LIKE '%Terrier%' OR `caption` LIKE '%Terrier%' OR `health_concerns` LIKE '%Terrier%' OR `temperment` LIKE '%Terrier%' OR `coat` LIKE '%Terrier%' OR `colors` LIKE '%Terrier%' OR `weight` LIKE '%Terrier%' OR `height` LIKE '%Terrier%' OR `country_of_origin` LIKE '%Terrier%' OR `living_environment` LIKE '%Terrier%' ) ) AND 1 AND `id` NOT IN ( SELECT `id` FROM `breeders_dbdoggies`.`doggie_breeds` WHERE ( 0 OR `breed_name` LIKE '%Cairn Terrier%' OR `description` LIKE '%Cairn Terrier%' OR `keywords` LIKE '%Cairn Terrier%' OR `caption` LIKE '%Cairn Terrier%' OR `health_concerns` LIKE '%Cairn Terrier%' OR `temperment` LIKE '%Cairn Terrier%' OR `coat` LIKE '%Cairn Terrier%' OR `colors` LIKE '%Cairn Terrier%' OR `weight` LIKE '%Cairn Terrier%' OR `height` LIKE '%Cairn Terrier%' OR `country_of_origin` LIKE '%Cairn Terrier%' OR `living_environment` LIKE '%Cairn Terrier%' ) AND 1 ) ) UNION ( SELECT 'doggies breed' as type, breeders_dbdoggies.`breeders_dbdoggies`.`doggie_breeds`.breed_name as title, CONCAT('http://www.doggies.com/', URI) as link, NOW() as `date` , '1' as `relevance` FROM `breeders_dbdoggies`.`doggie_breeds` WHERE ( 0 OR `breed_name` LIKE '%Cairn%' OR `description` LIKE '%Cairn%' OR `keywords` LIKE '%Cairn%' OR `caption` LIKE '%Cairn%' OR `health_concerns` LIKE '%Cairn%' OR `temperment` LIKE '%Cairn%' OR `coat` LIKE '%Cairn%' OR `colors` LIKE '%Cairn%' OR `weight` LIKE '%Cairn%' OR `height` LIKE '%Cairn%' OR `country_of_origin` LIKE '%Cairn%' OR `living_environment` LIKE '%Cairn%' OR `breed_name` LIKE '%Terrier%' OR `description` LIKE '%Terrier%' OR `keywords` LIKE '%Terrier%' OR `caption` LIKE '%Terrier%' OR `health_concerns` LIKE '%Terrier%' OR `temperment` LIKE '%Terrier%' OR `coat` LIKE '%Terrier%' OR `colors` LIKE '%Terrier%' OR `weight` LIKE '%Terrier%' OR `height` LIKE '%Terrier%' OR `country_of_origin` LIKE '%Terrier%' OR `living_environment` LIKE '%Terrier%' ) AND 1 AND `id` NOT IN ( SELECT `id` FROM `breeders_dbdoggies`.`doggie_breeds` WHERE ( 1 AND ( 0 OR `breed_name` LIKE '%Cairn%' OR `description` LIKE '%Cairn%' OR `keywords` LIKE '%Cairn%' OR `caption` LIKE '%Cairn%' OR `health_concerns` LIKE '%Cairn%' OR `temperment` LIKE '%Cairn%' OR `coat` LIKE '%Cairn%' OR `colors` LIKE '%Cairn%' OR `weight` LIKE '%Cairn%' OR `height` LIKE '%Cairn%' OR `country_of_origin` LIKE '%Cairn%' OR `living_environment` LIKE '%Cairn%' ) AND ( 0 OR `breed_name` LIKE '%Terrier%' OR `description` LIKE '%Terrier%' OR `keywords` LIKE '%Terrier%' OR `caption` LIKE '%Terrier%' OR `health_concerns` LIKE '%Terrier%' OR `temperment` LIKE '%Terrier%' OR `coat` LIKE '%Terrier%' OR `colors` LIKE '%Terrier%' OR `weight` LIKE '%Terrier%' OR `height` LIKE '%Terrier%' OR `country_of_origin` LIKE '%Terrier%' OR `living_environment` LIKE '%Terrier%' ) ) AND 1 ) ) UNION ( SELECT 'doggies articles' as type, article_title as title, CONCAT('http://www.doggies.com/articles/', id, '-', REPLACE(REPLACE(REPLACE(REPLACE(LOWER(article_title), ' ', ' '), ' ', '-'), '--', '-'), '--', '-'), '.html') as link, article_date as 'date', '3' as `relevance` FROM `long_articles` WHERE ( 0 OR `article_title` LIKE '%Cairn Terrier%' OR `article_page_title` LIKE '%Cairn Terrier%' OR `article_meta_description` LIKE '%Cairn Terrier%' OR `article_blurb` LIKE '%Cairn Terrier%' OR `article_keywords` LIKE '%Cairn Terrier%' ) AND article_category != '' ) UNION ( SELECT 'doggies articles' as type, article_title as title, CONCAT('http://www.doggies.com/articles/', id, '-', REPLACE(REPLACE(REPLACE(REPLACE(LOWER(article_title), ' ', ' '), ' ', '-'), '--', '-'), '--', '-'), '.html') as link, article_date as 'date', '2' as `relevance` FROM `long_articles` WHERE ( 1 AND ( 0 OR `article_title` LIKE '%Cairn%' OR `article_page_title` LIKE '%Cairn%' OR `article_meta_description` LIKE '%Cairn%' OR `article_blurb` LIKE '%Cairn%' OR `article_keywords` LIKE '%Cairn%' ) AND ( 0 OR `article_title` LIKE '%Terrier%' OR `article_page_title` LIKE '%Terrier%' OR `article_meta_description` LIKE '%Terrier%' OR `article_blurb` LIKE '%Terrier%' OR `article_keywords` LIKE '%Terrier%' ) ) AND article_category != '' AND `id` NOT IN ( SELECT `id` FROM `long_articles` WHERE ( 0 OR `article_title` LIKE '%Cairn Terrier%' OR `article_page_title` LIKE '%Cairn Terrier%' OR `article_meta_description` LIKE '%Cairn Terrier%' OR `article_blurb` LIKE '%Cairn Terrier%' OR `article_keywords` LIKE '%Cairn Terrier%' ) AND article_category != '' ) ) UNION ( SELECT 'doggies articles' as type, article_title as title, CONCAT('http://www.doggies.com/articles/', id, '-', REPLACE(REPLACE(REPLACE(REPLACE(LOWER(article_title), ' ', ' '), ' ', '-'), '--', '-'), '--', '-'), '.html') as link, article_date as 'date', '1' as `relevance` FROM `long_articles` WHERE ( 0 OR `article_title` LIKE '%Cairn%' OR `article_page_title` LIKE '%Cairn%' OR `article_meta_description` LIKE '%Cairn%' OR `article_blurb` LIKE '%Cairn%' OR `article_keywords` LIKE '%Cairn%' OR `article_title` LIKE '%Terrier%' OR `article_page_title` LIKE '%Terrier%' OR `article_meta_description` LIKE '%Terrier%' OR `article_blurb` LIKE '%Terrier%' OR `article_keywords` LIKE '%Terrier%' ) AND article_category != '' AND `id` NOT IN ( SELECT `id` FROM `long_articles` WHERE ( 1 AND ( 0 OR `article_title` LIKE '%Cairn%' OR `article_page_title` LIKE '%Cairn%' OR `article_meta_description` LIKE '%Cairn%' OR `article_blurb` LIKE '%Cairn%' OR `article_keywords` LIKE '%Cairn%' ) AND ( 0 OR `article_title` LIKE '%Terrier%' OR `article_page_title` LIKE '%Terrier%' OR `article_meta_description` LIKE '%Terrier%' OR `article_blurb` LIKE '%Terrier%' OR `article_keywords` LIKE '%Terrier%' ) ) AND article_category != '' ) ) UNION ( SELECT 'blog' as type, breeders_doggieswp1.wp_posts.post_title as title, breeders_doggieswp1.wp_posts.guid as link, breeders_doggieswp1.wp_posts.post_date_gmt as `date` , '3' as `relevance` FROM `breeders_doggieswp1`.`wp_posts` WHERE ( 0 OR `breeders_doggieswp1`.`wp_posts`.`post_name` LIKE '%Cairn Terrier%' OR `breeders_doggieswp1`.`wp_posts`.`post_content` LIKE '%Cairn Terrier%' ) AND breeders_doggieswp1.wp_posts.post_status = 'publish' ) UNION ( SELECT 'blog' as type, breeders_doggieswp1.wp_posts.post_title as title, breeders_doggieswp1.wp_posts.guid as link, breeders_doggieswp1.wp_posts.post_date_gmt as `date` , '2' as `relevance` FROM `breeders_doggieswp1`.`wp_posts` WHERE ( 1 AND ( 0 OR `breeders_doggieswp1`.`wp_posts`.`post_name` LIKE '%Cairn%' OR `breeders_doggieswp1`.`wp_posts`.`post_content` LIKE '%Cairn%' ) AND ( 0 OR `breeders_doggieswp1`.`wp_posts`.`post_name` LIKE '%Terrier%' OR `breeders_doggieswp1`.`wp_posts`.`post_content` LIKE '%Terrier%' ) ) AND breeders_doggieswp1.wp_posts.post_status = 'publish' AND `guid` NOT IN ( SELECT `guid` FROM `breeders_doggieswp1`.`wp_posts` WHERE ( 0 OR `breeders_doggieswp1`.`wp_posts`.`post_name` LIKE '%Cairn Terrier%' OR `breeders_doggieswp1`.`wp_posts`.`post_content` LIKE '%Cairn Terrier%' ) AND breeders_doggieswp1.wp_posts.post_status = 'publish' ) ) UNION ( SELECT 'blog' as type, breeders_doggieswp1.wp_posts.post_title as title, breeders_doggieswp1.wp_posts.guid as link, breeders_doggieswp1.wp_posts.post_date_gmt as `date` , '1' as `relevance` FROM `breeders_doggieswp1`.`wp_posts` WHERE ( 0 OR `breeders_doggieswp1`.`wp_posts`.`post_name` LIKE '%Cairn%' OR `breeders_doggieswp1`.`wp_posts`.`post_content` LIKE '%Cairn%' OR `breeders_doggieswp1`.`wp_posts`.`post_name` LIKE '%Terrier%' OR `breeders_doggieswp1`.`wp_posts`.`post_content` LIKE '%Terrier%' ) AND breeders_doggieswp1.wp_posts.post_status = 'publish' AND `guid` NOT IN ( SELECT `guid` FROM `breeders_doggieswp1`.`wp_posts` WHERE ( 1 AND ( 0 OR `breeders_doggieswp1`.`wp_posts`.`post_name` LIKE '%Cairn%' OR `breeders_doggieswp1`.`wp_posts`.`post_content` LIKE '%Cairn%' ) AND ( 0 OR `breeders_doggieswp1`.`wp_posts`.`post_name` LIKE '%Terrier%' OR `breeders_doggieswp1`.`wp_posts`.`post_content` LIKE '%Terrier%' ) ) AND breeders_doggieswp1.wp_posts.post_status = 'publish' ) ) UNION ( SELECT 'breeders articles' as `type`, `breeders_dbbreeder`.`articles`.`title` as `title`, `breeders_dbbreeder`.`articles`.`id` as `link`, `breeders_dbbreeder`.`articles`.`created` as `date` , '3' as `relevance` FROM `breeders_dbbreeder`.`articles` WHERE ( 0 OR `breeders_dbbreeder`.`articles`.`title` LIKE '%Cairn Terrier%' OR `breeders_dbbreeder`.`articles`.`short_description` LIKE '%Cairn Terrier%' ) AND 1 ) UNION ( SELECT 'breeders articles' as `type`, `breeders_dbbreeder`.`articles`.`title` as `title`, `breeders_dbbreeder`.`articles`.`id` as `link`, `breeders_dbbreeder`.`articles`.`created` as `date` , '2' as `relevance` FROM `breeders_dbbreeder`.`articles` WHERE ( 1 AND ( 0 OR `breeders_dbbreeder`.`articles`.`title` LIKE '%Cairn%' OR `breeders_dbbreeder`.`articles`.`short_description` LIKE '%Cairn%' ) AND ( 0 OR `breeders_dbbreeder`.`articles`.`title` LIKE '%Terrier%' OR `breeders_dbbreeder`.`articles`.`short_description` LIKE '%Terrier%' ) ) AND 1 AND `breeders_dbbreeder`.`articles`.`id` NOT IN ( SELECT `breeders_dbbreeder`.`articles`.`id` FROM `breeders_dbbreeder`.`articles` WHERE ( 0 OR `breeders_dbbreeder`.`articles`.`title` LIKE '%Cairn Terrier%' OR `breeders_dbbreeder`.`articles`.`short_description` LIKE '%Cairn Terrier%' ) AND 1 ) ) UNION ( SELECT 'breeders articles' as `type`, `breeders_dbbreeder`.`articles`.`title` as `title`, `breeders_dbbreeder`.`articles`.`id` as `link`, `breeders_dbbreeder`.`articles`.`created` as `date` , '1' as `relevance` FROM `breeders_dbbreeder`.`articles` WHERE ( 0 OR `breeders_dbbreeder`.`articles`.`title` LIKE '%Cairn%' OR `breeders_dbbreeder`.`articles`.`short_description` LIKE '%Cairn%' OR `breeders_dbbreeder`.`articles`.`title` LIKE '%Terrier%' OR `breeders_dbbreeder`.`articles`.`short_description` LIKE '%Terrier%' ) AND 1 AND `breeders_dbbreeder`.`articles`.`id` NOT IN ( SELECT `breeders_dbbreeder`.`articles`.`id` FROM `breeders_dbbreeder`.`articles` WHERE ( 1 AND ( 0 OR `breeders_dbbreeder`.`articles`.`title` LIKE '%Cairn%' OR `breeders_dbbreeder`.`articles`.`short_description` LIKE '%Cairn%' ) AND ( 0 OR `breeders_dbbreeder`.`articles`.`title` LIKE '%Terrier%' OR `breeders_dbbreeder`.`articles`.`short_description` LIKE '%Terrier%' ) ) AND 1 ) ) ORDER BY `relevance` DESC, `date` DESC LIMIT 11 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.breed_name as title, CONCAT('http://www.doggies.com/', URI) as link, NOW() as `' at line 38