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 = '700376'
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 30 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
, also known as Austrian pine or European black pine, is a versatile species of coniferous evergreen tree. It can reach heights of 20-55 meters and is moderately fast-growing, making it an ideal tree for street planting and as an ornamental tree in gardens and parks. It is resistant to snow, ice, and salt spray and has intermediate drought tolerance. The timber is used for rough carpentry and furniture, and the tree has a lifespan of over 500 years. Pinus nigra is found across southern Mediterranean Europe, from Spain to the eastern Mediterranean, and is also planted successfully as far north as Edmonton, Alberta, Canada. However, it is important to note that Austrian pine is currently facing a serious problem with red band needle blight disease caused by a fungus and is not recommended for landscaping, especially in groups or rows. Overall, Pinus nigra is a valuable and adaptable tree, highly suitable for landscaping and forestry purposes.