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

EPHESUS SULTANA WHITE 13% 75 CL

Box £37.46
 Each £7.49

EPHESUS OKUZGOZU RED WINE 75 CL

Box £37.46
 Each £6.63

EPHESUS WINE CALKARASI ROSE 75CL

Box £37.46
 Each £6.63