Kenic Lustre Coat Shampoo

Kenic Lustre Coat Shampoo is formulated for the dark coated pet. Highlights darker colors including reds. Hypoallergenic detergent free formulation. Neutral pH. Will not strip the coat. Rinses fast. May be used as often as necessary. Kenic Lustre Coat Shampoo dilutes 15 to 1.

  • Model: K2010 17oz,K2020 Gallon
  • 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
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '322' and opa.orders_id = opb.orders_id and opb.products_id != '322' 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]