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

ONCU TOMATO PASTE 830G

Box £21
 Each £2.49

ONCU HOT PEPPER PASTE 4300G

Box £71.8
 Each £18.95

ONCU POMAGRANETE SAUCE 700G

Box £25
 Each £1.99

ONCU POMEGRANATE SAUCE 4 KG

Box £57
 Each £9.95

ONCU PEPPER PASTE MILD 4300G

Box £71.8
 Each £18.95

ONCU TOMATO PASTE TIN 4.35 KG

Box £48
 Each £17.49

ONCU PET TOMATO PASTE 4300 gr

Box £71
 Each £17.95

ONCU MILD PEPPER PASTE 3200GR

Box £59.8
 Each £15.95

ONCU HOT PEPPER PASTE 3200GR

Box £59.8
 Each £15.95

ONCU MILD PEPPER PASTE 1650GR

Box £52.95
 Each £8.99