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

KTC POMACE OIL 5 LT

Box £69.95
 Each £17.95

KTC COOKING OIL 20 LT

Box £0
 Each £28.95

KTC PEELED PLUM TOMATOES 2650

Box £24.95
 Each £5.25

KTC CHOPPED TOMATOES 2.5 KG

Box £21.95
 Each £4.45

SUPERFRY COOKING OIL 20 lt

Box £0
 Each £26.95

KTC RAPESEED COOKING OIL 20 LT

Box £0
 Each £32.95