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

G MORRIS COOKED CHICKEN BREASTS 10-12OZ

Box £62.95
 Each £15.95