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

HUMBER VALLEY TORTILLA WRAPS 900 gr

Box £20.95
 Each £2.49

H.VALLEY PIZZA CUT PINEAPPLE 830 gr

Box £21.95
 Each £1.99