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

WHAM® ANTI-ITCH SPRAY - 8oz

Natures Specialties
   
Status: In Stock
   
Model/SKU: 151085

(2 reviews)
WHAM® ANTI-ITCH SPRAY - 8oz 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: $14.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(228,285,114,259,209,249,147,228,221,92,347,83,269,115,90,115,228,146,293,230,190,228,210,112,130,158,197,226,114,304,187,108,271,228,229,84,111,230,90,268,207,222,97,160,232,222,157,152,198,82,271,121,91,197,266,221,271,82,115,84,190,207,199,83,121,110,157,169,111,230,91,233,207,233,114,90,238,84,90,90,91,228,159,342,117,202,83,235,293,233,243,211,315,207,207,158,90,91,144,144,102,116,83,189,211,82,120,211,208,106,218,261,82,139,110,139,90,82,224,110,271,221,91,82,128,115,143,110,252,90,108,182,92,315,142,83,105,110,245,271,217,84,115,207,141,129,157,253,84,303,271,110,94,84,325,148,271,230,115,83,209,90,150,142,150,237,146,187,218,303,152,223,140,249,271,211,233,231,90,211,211,130,271,97,326,304,209,328,108,315,227,90,271,116,82,315,219,311,235,271,146,211,288,198,145,131,99,225,181,245,293,84,271,233,90,158,325,90,233,101,111,110,221,140,117,114,233,92,233,130,211,146,82,311,327,214,114,219,237,211,97,271,227,110,82,187,92,90,151,139,106,302,271,84,164,311,91,315,116,116,209,121,118,141,211,111,113,221,110,)

[TEP STOP]