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 = '28'
OMRON was founded in Japan in 1933 by Kazuma Tateisi as an electric manufacturing company. Since the beginning OMRON has presented itself as an innovative industry leader in automation, sensing and control technology. Since then, many everyday produc...ts and services were invented and introduced to society.
