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

SUPRIMA P.CHEESE 80/20 1.8KG

Box £52.5
 Each £10.75