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 = '700675'
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: cold stratify for 90 days
Germination: sow seed 1/4" deep , tamp the soil, mulch the seed bed
Introducing Pinus sylvestris, also known as the Scots Pine, the only pine tree native to northern Europe. With its blue-green leaves and orange-red bark, this tree is easily identified and highly valued in forestry. Its wood is commonly used for pulp and sawn timber products. The Scots Pine has a wide distribution range, from Ireland to eastern Siberia and from the Arctic Circle to the Caucasus Mountains. It can grow at sea level and at high altitudes up to 2,600m. This tree has been widely cultivated and was among the first trees introduced to North America in the early 1600s. Learn more about the Scots Pine at plants.usda.gov.