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 = '3150'
LipIce is a fun and fashionable brand of lip care products to keep your lips soft, moisturized and healthy throughout the day. It offers a wide range of lip products suitable for all occasions and lifestyles. It is created by the Mentholatum Company ...who has provided daily and family health care for over 100 years in over 150 countries.
