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 = '700017'
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 60 days
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
The Pinus durangensis, or Durango Pine, is a majestic evergreen tree species endemic to the Sierra Madre Occidental mountain range of Northwestern Mexico. With a height of 25-40 meters and a broad, rounded crown, this tree is one of the most impressive of Mexican pines. Its bark is thick, dark gray-brown, and scaly or fissured, and its leaves are needle-like, dark green, and come in groups of five to seven (mostly six), which is unique in the genus. The cones of the Durango Pine are oval and ripe in spring, and the seeds have a wing that is 1.5-2.5 cm long. This tree species is mainly found at a moderately high altitude of 1,500–2,800 meters, growing from Chihuahua and Sonora to Michoacán. While it is currently one of Mexico's more important timber trees, logging has greatly reduced its range. However, it is currently managed with sustainable, uneven-aged harvest methods. The Durango Pine forms extensive pure stands, creating parklike forests of large, tall trees that cover the landscape over tens or hundreds of square kilometers. These forests invite a walk or a drive through them and are one of the reasons why so many westerns have been filmed in Durango. Check out this iconic tree species on your next hike through Northwestern Mexico.