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

SABAT LARGE WHITE PITTA BREADX6

Box £14.95
 Each £1.09

SABAT SMALL PITA BREAD x6

Box £18.95
 Each £0.99