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(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,83,219,318,221,265,221,112,224,207,207,84,116,181,311,211,271,195,141,114,187,227,233,91,260,207,237,121,139,207,259,139,147,325,82,117,230,82,84,83,190,84,181,222,221,84,91,219,233,90,97,232,315,108,271,235,116,202,348,92,150,157,110,139,129,147,152,260,154,318,230,315,293,159,209,315,84,284,233,258,224,147,233,211,221,152,325,114,131,245,130,327,219,90,221,84,147,97,114,114,219,100,86,84,258,101,147,271,198,157,173,222,110,303,303,303,160,227,187,116,221,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,)

[TEP STOP]