select DISTINCT id, product_description, brand_name, tax_included, tax_rate, single_price, box_price, product_hash from v_box_product where brand_id ='26' Box Foods

EXTRA HOT CHILLI SAUCE 2.27 LT

Box £12.79
 Each £6.95

BARBEQUE SAUCE BBQ 2.27 LT

Box £12.95
 Each £6.99