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

VENUS PILAVLIK BULGUR 5KG

Box £49.95
 Each £12.95

VENUS KOFTELIK FINE BULGUR 5 KG

Box £32
 Each £8.95

VENUS KEKIK THYME 750gr

Box £45.5
 Each £9.45

GREENS SCOTTISH GAR MUSHROOMS 900g

Box £36
 Each £3.99

40KG LAMB DONER HALAL

Box £0
 Each £151.95