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 = '185'
Alcon
Alcon helps people see brilliantly. As the global leader in eye care with a heritage spanning more than seven decades, we offer the broadest portfolio of products to enhance sight and improve people’s lives.
Happening Now
FREE SHIPPING
Enjoy RM6 OFF on Shipping Fee for orders over RM100, available for both West and East Malaysia