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

PEPSI MAX 1.5L

Box £12.5
 Each £1.24

DIET PEPSI BOTTLE 1.5 LT

Box £12
 Each £1.24

PEPSI DIET CAN 330ml

Box £8.29
 Each £0.58

PEPSI MAX CAN 330ml

Box £8.29
 Each £0.58

PEPSI CAN 330 ml

Box £7.08
 Each £0.63

PEPSI BOTTLE 1.5 LT

Box £9.96
 Each £1.46