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

CAYKUR FILIZ BLACK TEA 500G

Box £43.5
 Each £4.95

CAYKUR RIZE TURIST TEA 500gr

Box £43.5
 Each £4.95

CAYKUR ALTINBAS 500G

Box £43.5
 Each £4.49

CAYKUR FILIZ BLACK TEA 1KG

Box £0
 Each £5.49

CAYKUR TIRYAKI CAYI 500gr

Box £43.5
 Each £3.99