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 = '566'
We are Colgate, a caring, innovative growth company that is reimagining a healthier future for people, their pets, and our planet. The world looks to Colgate for health and hygiene products to enable the well-being of their families and cleaner, gree...ner living. We leverage the power and potential of science, purposeful packaging and long-trusted brands to build a brighter future for people around the world. For Colgate, our company purpose and the value of our products are directly tied to how well we execute on sustainability, recognizing the profound responsibility we have to all those we s
