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

KILIKYA GRAPE VINEGAR PET 500ml

Box £15.8
 Each £0.99

KILIKYA GRAPE VINEGAR PET 1 LT

Box £12
 Each £1.25

KILIKYA HOT SALGAM 2 LT

Box £10
 Each £2.08

KILIKYA HOT SALGAM 1 LT

Box £15
 Each £1.49

KILIKYA MILD SALGAM 2 LT

Box £12
 Each £2.49