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

EFES PILSENER BEER TIN 50 CL

Box £29.13
 Each £1.49

EFES DRAFT BROWN BOTTLE 50 CL

Box £21.63
 Each £2.08

EFES PILSENER BOTTLE 33CL

Box £22.92
 Each £1.03

EFES DRAFT KEG 30 LT

Box £0
 Each £78.29