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 = '1222'
Since 1889, The Mentholatum Company has grown and prospered from a small purveyor of soaps and toiletries into an international company, marketing quality healthcare products around the world. In the United States and many countries around the world,... the Mentholatum family of products has earned a reputation of quality and value. Every Mentholatum brand is sold with an unconditional guarantee of satisfaction.
