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

CHICKEN FILLET BURGER SUN VALLEY (120GR) 1.8KG

Box £27.85
 Each £13.95

CHICKEN STRIPS MINI FILLET SFC sun valley 1Kg

Box £44.99
 Each £7.95

CHICKEN FILLET HOT n SPICY sun valley 1.8g

Box £29.85
 Each £14.95

CHICKEN NUGGETS SUN VALLEY 1 KG

Box £25.95
 Each £4.99

CHICKEN STRIPS GOUJONS SFC sun valley 1Kg

Box £44.99
 Each £7.99