Currencies:
US Dollar
Euro
GB Pound
Canadian Dollar
Australian Dollar
Search:
Home
Home
New Products
Product Reviews
Event
Dealers
About Us
Contact Us
Categories
Boss Nation Brands
Grrrowl Pet Food NZ
Medicus Veterinary Diet
Portland Pet Food
Dog Food
Cat Food
Treats
Vitamins & Supplements
Grooming / Hygiene
Clean Up & Litter
Flea & Ticks Control
Kenic Skin Care
Toys & Gift
Feeder
Others
Chews and Bones
Manufacturers
Please Select
Boss Nation Bra..
Clump 'N Flush ..
Dr. Becker's Bi..
Eco-me
Grandma Lucy's
Grrrowl Pet Foo..
Herbsmith
Imperial Cat
Jolly Pets
Kenic
Laughing Dog
Medicus Veterin..
Modko
Nature's Logic
Nutri-Vet
PawGanics
Pioneer Pet
Pioneer Pet Fou..
PoochPads
Portland Pet Fo..
SmartCat
Sunday Pets
trueblue pet
Wagatha's Organ..
Wapiti Labs Inc
Whole Life Pet
New Products [more]
Herbsmith - Sound Dog Viscosity
Reviews [more]
Write a review on this product.
Categories
Boss Nation Brands
Grrrowl Pet Food NZ
Medicus Veterinary Diet
Portland Pet Food
Dog Food
Cat Food
Treats
Vitamins & Supplements
Grooming / Hygiene
Clean Up & Litter
Flea & Ticks Control
Kenic Skin Care
Toys & Gift
Feeder
Others
Chews and Bones
Manufacturers
Please Select
Boss Nation Bra..
Clump 'N Flush ..
Dr. Becker's Bi..
Eco-me
Grandma Lucy's
Grrrowl Pet Foo..
Herbsmith
Imperial Cat
Jolly Pets
Kenic
Laughing Dog
Medicus Veterin..
Modko
Nature's Logic
Nutri-Vet
PawGanics
Pioneer Pet
Pioneer Pet Fou..
PoochPads
Portland Pet Fo..
SmartCat
Sunday Pets
trueblue pet
Wagatha's Organ..
Wapiti Labs Inc
Whole Life Pet
New Products [more]
Imperial Cat - Shape Scratchers Cozy Curl
Reviews [more]
Write a review on this product.
Kenic Hot Spot Anit-Itch Spray
Kenic Skin Care
Product 4/7
larger image
Contact Us
Kenic Hot Spot Anit-Itch Spray is made with the finest ingredients found in nature. This product will provide soothing and cooling to the skin without using steroids. Relieves burning and itching from hot spots, flea bite allergy, food allergies and grass fungus.
Model: K4905 8oz
Manufactured by: Kenic
This product was added to our catalog on Friday 15 July, 2011.
1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'caesarsd_shop.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '334' and opa.orders_id = opb.orders_id and opb.products_id != '334' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]