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

WHAM® ANTI-ITCH SPRAY - 8oz

Natures Specialties
   
Status: In Stock
   
Model/SKU: 151085

(1 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(157,84,271,90,224,211,82,327,146,288,219,90,232,108,141,115,115,146,84,101,91,144,116,169,230,271,326,209,94,325,221,83,318,114,237,221,325,131,130,235,82,121,197,230,228,315,83,110,189,82,233,111,221,108,227,230,84,190,265,112,228,114,209,147,219,202,235,233,221,82,303,223,249,271,84,311,315,116,117,233,159,315,284,181,221,230,268,222,160,221,221,82,115,211,207,131,225,245,211,231,260,237,139,121,141,173,110,303,258,147,233,90,84,90,222,230,83,90,110,90,227,82,92,84,233,157,139,147,259,147,197,114,187,160,187,106,261,139,139,228,116,315,311,142,237,84,181,211,151,106,114,219,86,260,318,199,121,157,271,129,253,303,138,82,130,146,311,271,211,233,97,315,195,114,90,228,293,258,147,144,102,83,111,130,97,304,110,84,113,110,219,214,219,152,114,245,271,116,271,91,266,190,210,142,105,245,211,90,101,110,328,315,117,82,83,221,221,285,259,249,327,90,83,293,243,271,115,152,140,271,217,164,91,116,140,114,293,209,84,84,222,90,207,97,228,92,91,128,143,315,207,99,181,293,233,91,207,121,209,118,157,222,303,233,224,114,238,90,)

[TEP STOP]