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 = '1472'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Looking for a fast-growing, hardy tree that's resistant to drought and Dutch elm disease? Consider the Siberian Elm, also known as the Asiatic Elm or Dwarf Elm. This small to medium-sized tree features deciduous leaves that turn from dark green to yellow in the fall and samara fruits dispersed by wind. While the Siberian Elm is short-lived in temperate climates, it can live up to 100-150 years in its native environment. This tree is native to northern China and Eastern Siberia, and has become naturalized in many places, including the United States. While it may not be the most ornamental tree, the Siberian Elm has historically been used as an ornamental species due to its rapid growth and provision of shade. The unripe seeds are also edible and have been a food source in Manchuria and China. Overall, this tree is a hardy choice for regions that experience severe cold and drought.