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 = '1409'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 120 days, cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Research Needed
Stewartia sinensis, also known as Chinese Stewartia, is a small deciduous tree or large shrub that is highly regarded horticulturally for its attractive, cinnamon-colored peeling bark, fragrant white flowers, and intense red fall foliage. Native to central and eastern China, it typically grows up to 9 meters tall but can reach up to 20 meters in its native forests. This tree is recommended for use where larger trees are unadvisable, such as under power lines. Its preferred growing conditions are similar to those of the more commonly cultivated Japanese stewartia, though it is somewhat less cold-tolerant. Stewartia sinensis is hardy to USDA zone 5 and has an attractive, multiply-branched growth habit with low maintenance requirements. Considered a specimen tree, it may be grown in climates that do not test its cold-tolerance. Protect young trees during very cold temperatures until they reach mature sizes.