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 = '1356'
Pigeon was founded in Japan in 1957 by Yuichi Nakata with the aim of meeting the needs of mothers worldwide by producing a range of high quality, durable and user-friendly merchandise for babies and mothers.
We value baby's health, comfort and mothe...r's convenience in using our products, so baby grows up healthy. These values shape each product we make at Pigeon.
At Pigeon, our wish is to become a partner in caring for your baby's healthy growth and the happiness of mother through advanced research, development & innovation.
