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 = '31'
At St. Ives, we use 100% natural moisturizers, exfoliants, and extracts to bring the joy of nature into our cruelty free skin products to give you soft, refreshed skin that glows! And we mean it, too! That’s why we celebrate the look and feel of re...al, natural skin and none of the models on our site have been retouched to hide any of their features that make them unique. Got it? Good! Now get your glow on! Once we find an ingredient we like, we’ll follow it around the world. To make sure we always use the best of what’s out there for our skincare, we keep track of their growing seasons at
