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

SLICED CHEESE KERRYMAID 1.4KG

Box £71.6
 Each £8.95

KERRYMAID CHEDDAR SAUCE 1KG

Box £59.88
 Each £4.99