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 = '974'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/8" deep, tamp the soil, mulch the seed bed
Schrenk's Spruce, also known as Picea schrenkiana, is a magnificent evergreen tree native to Central Asia, specifically the Tian Shan Mountains in western China, Kazakhstan, Kyrgyzstan, and northern Pakistan. It can grow up to 60 meters tall with a trunk diameter of up to 2 meters, featuring a narrow conical crown with level branches and sometimes pendulous branchlets. The tree typically grows at altitudes of 1300-3600 meters and can be found in pure forests mixed with Siberian fir (Abies sibirica var. semenovii). Its leaves are needle-like, dull green, and 1.5 to 3.5 cm long, while its cones are oval to cylindrical and 6 to 12 cm long. Schrenk's Spruce is an important tree for timber and paper production in central Asia. However, because of its slower growth compared to the Norway Spruce, it is not as widely used outside its native range. In Europe, Schrenk's Spruce is often found in large gardens and public parks as an ornamental tree. The Schrenk's Spruce owes its name to Alexander von Schrenk, a Russian botanist who explored Central Asia in the 19th century.