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 = '3484'
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
Introducing the Ulmus alata Winged Elm, a striking medium-sized deciduous tree that can grow up to 27 meters tall with a variable canopy form from pyramidal to rounded. One of its most unique features are the very broad, thin pair of corky wings that form along the branchlets after a few years, giving it a distinct look. The leaves are small, oblong-lanceolate to narrowly elliptic, and smooth above with a dark green color that turns yellow in the fall. Inconspicuous brownish-green flowers appear in clusters before the leaves emerge. The Ulmus alata Winged Elm is native to Virginia to Texas and is tolerant of urban environments. It grows well in average, medium moisture, well-drained soils in full sun, and adapts to both moist and dry sites. Regular pruning of young trees is recommended to eliminate multiple trunks. Don't miss the opportunity to add this unique and beautiful tree to your garden or landscape.