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 = '1060'
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 metres tall in the forests of Järvselja). The Scots Pine, also known as the Pinus sylvestris or Scotch Pine, is native to northern Europe and Asia, and has been an important tree in forestry for centuries. Its wood is commonly used for pulp and sawn timber products. This coniferous tree is extremely adaptable to various soils and can be found from sea level up to 2,600m altitude in mountainous regions. The mature tree is distinctive due to its long, bare and straight trunk topped by a rounded or flat-topped mass of foliage. The blue-green needles can grow up to 5 cm long and persist for several years. The Scots Pine has a lifespan of 150-300 years, with the oldest recorded specimens in Sweden reaching over 700 years. Additionally, its irregular pyramid shape in youth makes it a popular choice as a Christmas tree.