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 = '940'
Thinking About Baby and You comes naturally to us at Pureen. For more than 40 years, we have focused exclusively on creating the finest products to help Baby and You feel better and look better. Given our ethical heritage, we are the expert who knows... you the best. Pureen products are made with the highest quality ingredients, the safest formulations, and the greatest care. It’s pure and simple, because our mission is Thinking About Baby and You!