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 = '1045'
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: none required
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Pinus roxburghii, commonly known as Chir Pine or Longleaf Indian Pine, is a large tree that grows up to 50 meters in height and 2 meters in diameter. This species of pine is native to the Himalayas and is found from northern Pakistan to Bhutan. It generally grows at a lower altitude than other pines and occurs from 500-2300 meters. The bark of Chir Pine is red-brown and thick, and the leaves are needle-like and yellowish-green. The cones are ovoid conic and green when closed, maturing to glossy chestnut-brown after 24 months. The wood of this tree is the weakest and most prone to decay compared to other conifers, but it is used widely for timber and also tapped commercially for resin. The resin yields an essential oil, commonly known as turpentine, which is used as a solvent in various industries. Additionally, the thick bark of this tree provides an easily-carvable material for the locals to make brooms, lids for vessels, and use as fuel for their furnaces. The dried needles of this tree also serve as bedding for cattle. This species is occasionally used as an ornamental tree in hot and dry areas as it is drought-tolerant.