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

BAYOLIVE EXT.VIRGIN OLIVE OIL 5 LT

Box £79.99
 Each £39.95