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 = '1431'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30-90 days
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
Syringa villosa, also known as the villous lilac, is a hardy deciduous shrub with a dense, rounded habit. It can reach heights of 6-10 feet and widths of 4-10 feet. The medium texture and moderate growth rate of this shrub make it an ideal addition to any garden or landscape. This shrub is known to do particularly well in the U.S. Midwest.
Syringa villosa is native to China and is found in regions such as Hebei, Shanxi, Heilongjiang, Jilin, and Liaoning. It is also native to parts of Korea and the southern part of the Russian Far East. There are two recognized subspecies of Syringa villosa, which are sometimes regarded as separate species.
This shrub features beautiful white or rosy-lilac flowers that grow in clusters of 3-7 inches. These clusters can often be found at the tips of several branches. The flowers are not highly fragrant, but they do resemble the scent of privet. Despite its modest fragrance, the Syringa villosa is highly valued for its hardiness and ability to thrive in various conditions.
With its dense, arching form and substantial branches, this shrub creates a stunning visual impact in any landscape. It adds height and structure, making it a great choice for hedges or as a standalone specimen. The Syringa villosa is also known for its moderate growth rate, allowing it to quickly establish itself in the garden.
Overall, the Syringa villosa is a versatile and hardy shrub that adds beauty and interest to any landscape. Its ability to withstand harsh Midwest winters and its attractive clusters of flowers make it a popular choice among gardeners. Whether used as a focal point in a garden or as a background plant, the Syringa villosa is sure to delight with its stunning blooms and impressive form.