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 = '1073'
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/8" deep , tamp the soil, mulch the seed bed
Looking for a hardy and versatile tree to add to your garden or forestry? Consider the Pinus sylvestris, also known as the Scots Pine or Scotch Pine. Native to Europe and Asia, this evergreen conifer can grow up to 75 ft in height, with some exceptional trees reaching up to 150 ft in Estonia. It has a conical to columnar shape and a thick, flaky orange-red bark when young, which becomes scaly and gray-brown in maturity. The needles are short (2-3 cm long), twisted, and blue-green in color. They are arranged in pairs on short shoots. The cones are cylindrical, 3-5 cm long, and light brown in color. They mature in one year. Whether you are looking for a Christmas tree, a source of timber, or an ornamental addition to your landscape, the Scots Pine is a great choice.