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

McCain MOZARELLA STICKS PICKERS 1Kg

Box £49.95
 Each £8.95

McCAIN VEGETABLE BURGER PACK 1.13 kg

Box £17.95
 Each £5.95

McCAIN ORIGINAL HASH BROWN 1 Kg

Box £23.6
 Each £2.95