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 = '1471'
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 and attractive tree that can grow almost anywhere? Look no further than the Ulmus parvifolia, also known as the Chinese Corkbark Elm, Chinese Elm, or Lacebark Elm. This deciduous or semi-deciduous tree is highly resistant to Dutch elm disease and unaffected by the Elm Leaf Beetle, making it an excellent choice for city streets, parking lots, or small planters along streets or plazas. Its bark often features attractive patches in shades of gray, green, orange, and brown, while its dark green and shiny leaves can turn yellowish to reddish purple in the fall. The Chinese Elm is also a popular choice for bonsai enthusiasts, as it has a high tolerance for pruning. Originally from northern China, Korea, and Japan, the Chinese Elm is now found on all continents except Antarctica, and is considered one of the hardiest and most splendid elms in the world. Whether you're a landscaper, gardener, or tree enthusiast, the Chinese Corkbark Elm is an outstanding plant that is sure to impress.