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

CHICKEN STRIPS MINI FILLET SFC TYSON 1KG

Box £69.5
 Each £8.5

POPCORN CHICKEN tyson1 Kg

Box £75
 Each £7.99

HOT CHICKEN WINGS TYSON 3 kg

Box £0
 Each £14.95

CHICKEN FILLET BURGER tyson 2.2 KG

Box £69.95
 Each £18.95

HOT CHICKEN WINGS TYSON 2.27 KG

Box £0
 Each £14.75