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

GREENS SCOTTISH GAR MUSHROOMS 900g

Box £36
 Each £3.95

40KG LAMB DONER HALAL

Box £0
 Each £151.95

MAJESTIC 1 OZ SAUCE CUPS 1000PCS

Box £0
 Each £14.58

2 OZ SAUCE CUPS 1000PCS uk imp&exp

Box £0
 Each £16.63

4 OZ SAUCE CUPS 1000PCS uk imp&exp

Box £0
 Each £15.41

Bucket Buffalo & Wringer 251 Red

Box £0
 Each £66.66