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 = '700444'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Other: don't get the seed too wet during germination or it can rot, keep it on the dryer side
Looking for a tough, attractive tree that will thrive in any soil and pH level? Check out the Ulmus parvifolia 'Elsmo' Chinese Corkbark Elm, also known as the Chinese Elm or Lacebark Elm. This small to medium deciduous tree is highly resistant to Dutch elm disease and unaffected by the Elm Leaf Beetle. Its mottled grey and red bark makes it a striking feature in any landscape, and its dark green and shiny leaves turn yellowish to reddish purple in the fall. The tree is tolerant of harsh planting situations such as parking lots and in plazas or patios. Chinese Elms are frequently used in bonsai, owing to their high tolerance of pruning. The Chinese Elm is hardy enough to grow in harsh planting situations and the durability of its wood makes it popular for furniture, cabins and hardwood flooring. Purchase this hardy and versatile tree today and enjoy it for many years to come!