Shop by Symptom
Shop by Coat Type
Attention Groomers & Retailers
NatureSpecialties

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(315,90,91,298,91,215,84,208,211,237,315,108,84,143,90,95,315,204,96,112,98,325,311,84,159,315,105,216,111,206,223,238,101,304,96,141,170,110,84,198,114,154,143,139,143,231,228,101,191,83,217,304,141,224,211,83,146,147,154,101,271,303,271,118,130,155,227,271,233,165,233,86,315,305,208,91,91,107,140,181,144,188,147,233,89,139,101,154,143,154,262,114,115,197,323,221,86,149,227,221,230,90,255,101,114,148,131,105,237,325,144,230,92,116,92,118,358,95,178,141,150,303,327,144,184,152,271,225,141,210,143,114,114,154,101,265,203,139,271,211,223,121,217,233,230,116,143,158,114,139,203,304,214,286,233,219,82,149,122,221,139,185,293,191,211,157,315,206,152,116,156,221,158,148,227,154,114,208,90,114,269,110,145,98,84,84,158,237,141,233,274,114,271,90,143,271,84,226,259,130,221,84,197,197,121,154,188,206,140,325,262,106,323,326,253,196,84,285,192,90,228,129,227,206,90,100,83,156,95,187,315,112,148,156,92,277,114,139,228,154,208,140,228,206,199,230,233,206,271,112,101,140,211,143,84,173,84,152,84,245,271,108,92,91,114,90,90,)

[TEP STOP]