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

DIET COKE 330 ml

Box £8.33
 Each £0.83

COCA COLA BOTTLE COKE 1.5 LT

Box £13.95
 Each £1.49

DIET COKE 1.25 LT

Box £14.96
 Each £1.58

COCA COLA COKE GB 330ML

Box £11.63
 Each £0.63

COCA COLA COKE CAN 330ML

Box £11.63
 Each £0.58

COCA COLA CHERRY 330 ML

Box £12.46
 Each £0.83