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

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

[TEP STOP]