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

PRE-FRIED GARLIC MUSHROOMS 1kg

Box £49.5
 Each £4.99