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

CHICKEN FILLET HOT N SPICY CROWN 1.98KG (110GR)

Box £44.85
 Each £14.95

CHICKEN FILLET BURGER CROWN 2.16 KG

Box £43.5
 Each £15