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 = '523'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 150 days, cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: Spring sowing of unstratified seed will produce germination the next spring
Corylopsis sinensis, commonly known as Chinese Winterhazel or Winter Hazel, is a beautiful multi-stemmed shrub native to western China. It typically grows 10-15 feet tall and features drooping clusters of mildly fragrant yellow-green flowers with orange anthers in early spring, providing a delightful burst of late winter to early spring bloom in the landscape. The flower stamens are shorter than the petals, and the fruits are pubescent capsules containing two small seeds. The obovate pointed dark green leaves are up to 4 inches long and are glaucous beneath, turning shades of yellow in fall. This shrub is perfect for shrub borders or woodland gardens and is easy to care for. It can adapt to any soil type and prefers partial shade to full sun. Winter Hazel is closely related to the Witch Hazel and the Forsythia, making it an excellent addition to any garden that values early bloomers.