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

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(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,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,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,233,91,303,95,90,245,112,140,289,114,139,96,84,90,143,237,367,90,102,84,238,152,92,112,152,84,99,228,150,101,114,233,206,172,83,155,95,102,211,197,96,103,107,147,105,112,211,236,197,280,255,152,150,182,163,271,112,267,139,101,211,148,90,90,315,82,237,129,130,84,121,91,82,355,114,90,92,271,181,117,237,141,304,227,82,132,271,120,210,108,285,221,210,158,84,284,91,158,237,172,114,124,188,211,114,325,372,131,114,154,288,221,271,141,230,214,102,206,143,139,203,271,273,220,256,315,208,116,230,150,149,146,160,206,121,92,228,83,206,111,213,152,157,211,187,91,191,245,347,228,227,155,304,)

[TEP STOP]