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

THEOS FILLO PASTRY YUFKA 400GR

Box £20.95
 Each £2.19

KADAYIF LOOSE FROZEN 5Kg

Box £38
 Each £19.95