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

L.WESTON CREAM CHEESE JALAPENOS 1KG

Box £59.5
 Each £10.95

L.WESTON TWISTERS POTATO CHIPS 2.5 Kg

Box £20.95
 Each £6.99

L.WESTON MOZARELLA STICKS 1 Kg

Box £54.95
 Each £9.95

LAMB WESTON HASH BROWN 1 kg

Box £24.95
 Each £2.69

LAMB WESTON WEDGES 2.5Kg

Box £21.95
 Each £6.49

L. WESTON CHIPS FRIES PRIVATE 9X9MM 3/8

Box £16.49
 Each £4.99