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 = '620'
Maybelline or Maybelline New York is an American multinational cosmetics, skin care, fragrance and personal care company, based in New York City. It was founded in Chicago in 1914, and has been a subsidiary of French cosmetics company L'Oréal since ...1996. Maybelline New York is the number one global cosmetics brand and is available in over 129 countries worldwide. Offering more than 200 products, Maybelline New York combines technologically advanced formulas with on-trend expertise to create accessible cosmetics with a cool, urban edge and a spirited style. Maybelline New York is the official
