Shop by Symptom
Shop by Coat Type
Attention Groomers & Retailers
Nature's Specialties Pro Starter Kit

WHAM® ANTI-ITCH SPRAY - 16oz

Natures Specialties
   
Status: In Stock
   
Model/SKU: 151160

(1 reviews)
WHAM® ANTI-ITCH SPRAY - 16oz is just one of 4 items in the WHAM®ANTI-ITCH SPRAY FOR DOGS & CATS group of products.
Share This:
bookmark email digg facebook googlebookmarks myspace stumbleupon twitter
Price: $22.00/Each
Purchase Options
Quantity: 
1064 - 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 ')' at line 15

SELECT DISTINCT p.*, pd.* FROM products p left join products_images pi on (pi.products_id=p.products_id and thumbnail=1) LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id LEFT JOIN categories c ON c.categories_id = p2c.categories_id LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id AND cd.language_id = 1 LEFT JOIN products_prices pp ON pp.product_id = p.products_id AND pp.qty=1 AND pp.group_id = 0 LEFT JOIN products_units pu ON pu.products_units_id = p.products_units_id LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id LEFT JOIN manufacturers_info mi ON mi.manufacturers_id = p.manufacturers_id ,products_description pd WHERE p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = 1 AND p.products_id IN(208,140,228,206,199,230,233,206,271,112,101,140,211,143,84,271,173,84,152,84,245,271,108,92,91,114,90,90,233,91,228,303,95,90,245,112,140,289,114,139,96,84,90,143,237,367,84,90,102,84,238,152,92,112,152,84,99,228,150,101,114,233,101,206,172,83,155,95,102,211,197,96,103,107,147,105,112,211,101,236,197,280,255,152,150,182,163,271,112,267,139,101,211,148,259,90,90,315,82,237,129,130,84,121,91,82,355,114,90,92,114,271,181,117,237,141,304,227,82,132,271,120,210,108,285,221,114,210,158,84,284,91,158,237,172,114,124,188,211,114,325,372,237,131,114,154,288,221,271,141,230,214,102,206,143,139,203,271,139,273,220,256,315,208,116,230,150,149,146,160,206,121,92,228,139,83,206,111,213,152,157,211,187,91,191,245,347,228,227,155,336,304,116,91,214,224,92,102,221,237,90,90,139,154,101,158,143,222,102,90,305,195,119,221,195,130,120,141,115,221,139,157,143,86,91,120,223,106,159,214,184,224,221,211,84,90,304,91,265,90,111,139,121,84,96,293,211,224,158,101,143,90,114,139,154,315,90,91,298,91,215,84,208,211,237,315,108,84,143,90,)

[TEP STOP]