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 = '1125'
Jordan is a Scandinavian brand under the ORKLA conglomerate and is best known for its contemporary range of quality oral care products. Available in 14 countries with over 2 billion users, the brand is the market leader for toothbrushes, dental floss... and dental sticks in Scandinavia and other parts of the world. Each product is made with carefully selected materials and purposeful design to suit different needs and preferences. From your first tooth to the last, you can count on Jordan to keep your teeth healthy for life.
