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

T.BAKE HALAL JUMBO SAUSAGE 4.5 Kg

Box £0
 Each £13.95

T.BAKE LARGE PITA BREAD X 6

Box £17.99
 Each £0.95

T.BAKE SMALL PITA BREAD x 6

Box £16.95
 Each £0.95