Brushing Spray
Ready to use. An effective way to reduce the amount of debris from the field. Repels dust, prevents coat matting, has a natural fragrance, and no heavy build up. Crown Royale Sporting Dog Sprays help protect your dog’s specific coat type, helps prevent static build up and keeps the coat in excellent condition.
Formula #12 – Designed for Full and Flat Coats
Formula #16 – Designed for Hard and Wiry Coats
This product was added to our catalog on Sunday 24 February, 2019.
1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'k9groomi_store.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 zen_orders_products opa, zen_orders_products opb, zen_orders o, zen_products p
where opa.products_id = '1058'
and opa.orders_id = opb.orders_id
and opb.products_id != '1058'
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]