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 = '3626'
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
220 year old trees that are 46 meters tall in the forests of Järvselja). The Scots Pine, also known as Pinus sylvestris, is the only pine native to Northern Europe and is an important tree in forestry. Its wood is used for pulp and sawn timber products. This species is extremely adaptable to various soils and was one of the first trees introduced to North America in the 1600s. The mature tree has a distinctive shape with a long, bare, and straight trunk topped by a rounded or flat-topped mass of foliage. Its blue-green needles persist for two to four years in warmer climates and up to nine years in subarctic regions. The Scots Pine produces red pollination cones that mature into yellow-brown cones and blackish seeds with pale brown wings. With a lifespan averaging 150-300 years, the Scots Pine is an iconic tree that offers many benefits for forestry and landscaping.