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

SALIMAH SALAMI HALAL 1kg

Box £0
 Each £8.95

HALAL PEPPERONI SALIMAH 1KG

Box £0
 Each £9.99

SALIMAH HALAL SPICY BEEF 1Kg

Box £69.5
 Each £6.95

SALIMAH TURKEY JULIENNE 1KG

Box £59.5
 Each £5.95