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 = '1023'
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
Pinus nigra, also known as Austrian Pine or Black Pine, is a species of pine that is native to southern Mediterranean Europe, including Spain, Turkey, Corsica, and Cyprus. It can also be found in the high mountains of North Africa. This large evergreen tree can grow to a height of 20-55 meters and has a rounded conic form. The bark is grey to yellow-brown and becomes more fissured with age. The leaves are thinner and more flexible in western populations. Pinus nigra is moderately fast-growing and can live for over 500 years. It requires full sun and is intolerant of shade. The wood of this tree is used for rough carpentry and furniture. It is commonly planted as a street tree in the US and Canada due to its resistance to salt spray and various pollutants. In the UK, it is planted as an ornamental tree in parks and gardens. Pinus nigra is suitable for light, medium, and heavy soils and can tolerate drought. It is not self-fertile and is pollinated by wind. The turpentine obtained from the resin of this tree has various medicinal uses and is used in the treatment of kidney and bladder complaints, respiratory diseases, and skin conditions. The tree also has other uses, such as dye production and wood preservation. It thrives in a sunny position and is tolerant of maritime exposure. Propagation can be done through seed sowing or cuttings. Overall, Pinus nigra is an attractive and versatile tree that is valued for its aesthetic appeal, durability, and medicinal properties.