select i.*, substring_index(group_concat(distinct pa.country order by rsi.date_added desc),',',-1) as source_country
from inventory_item_manage i
left outer join sheffields_2017.receiving_shipments_item_has_inventory_item hrsi on i.id = hrsi.inventory_item_id
left outer join sheffields_2017.receiving_shipments_item rsi on rsi.id = hrsi.receiving_shipments_item_id
left outer join sheffields_2017.po on rsi.po_id = po.id
left outer join sheffields_2017.po_address pa on pa.po_id = po.id
where i.inventory_id = '1012'
group by i.id
Australia, Austria, Belgium, Bulgaria, Colombia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, New Zealand, Poland, Portugal, Romania, Slovak Republic, Slovenia, Spain, Sweden, Switzerland, Turkey, United Kingdom
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 60 days, cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Introducing the Pinus koraiensis, also known as the Korean Pine or Chinese Pinenut. This tree species is native to eastern Asia, including Manchuria, far eastern Russia, Korea, and central Japan. It can grow up to 50 meters tall with a trunk diameter of 1.5-2 meters. The seeds are extensively harvested and sold as pine nuts, particularly in northeastern China. The nut oil contains 11.5% of the unusual fatty acid pinolenic acid. The Korean Pine is a popular ornamental tree in cold climates and is tolerant of severe winter cold, hardy down to about -50 °C. It is also used for construction, furniture, and wood pulp. The seeds have medicinal properties and are used to promote milk flow in nursing mothers and as an analgesic and antibacterial in Korea. Invest in the versatile and unique Pinus koraiensis for your garden or for its many beneficial uses.