select m.manufacturers_id, m.manufacturers_name, m.address_key, mi.manufacturers_meta_title, mi.manufacturers_meta_descp, mp.manufacturersportion_image from manufacturers m left join manufacturers_portion mp on m.manufacturers_id = mp.manufacturers_id and mp.manufacturersportion_position = 'Left Menu', manufacturers_info mi where m.manufacturers_id = mi.manufacturers_id and m.manufacturers_id = '3194'
Raya Hamper
Our hampers consists of a huge range of product from healthy organic foods and beverages to premium dates, raisins and herbs. Perfect for corporate gifting, sending to friends and family, or even for your own enjoyment.
