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 = '701'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 90 days, cold stratify for 90 days
Germination: sow 1-2" deep, tamp the soil, mulch the seed bed
Introducing Mountain Silverbell, an ornamental tree native to the Appalachian Mountains in the southeastern United States. This deciduous tree or large shrub stands at 20-40 feet tall and boasts bell-shaped, white flowers appearing in clusters in spring. Its elliptic to oblong-obovate medium green leaves add to its summer charm, turning yellow in fall. The tree's exfoliating bark adds to its winter interest. Similar to Halesia Carolina, its flowers are larger. Named after British clergyman and plant physiologist Stephen Hales, this tree is a beauty to behold. While it may grow to 40-80 feet tall in its native habitat, it is usually smaller when cultivated. Its four-winged fruits mature in the fall, providing an added touch of beauty. Consider the Mountain Silverbell for your garden to add unique beauty and interest year-round.