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 = '2574'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 150 days
Germination: surface sow and keep moist, tamp the soil, keep moist, mulch the seed bed
Other: Full germination may take up to 180 days.
Introducing Holodiscus discolor Cream Bush, also known as Ocean Spray. This shrub, native to western North America, is a stunning addition to any garden. Commonly referred to as creambush or ironwood, Holodiscus discolor can be found in the Pacific Northwest, thriving in both open spaces and the forest understory at low to moderate elevations.
The Cream Bush is a fast-growing plant that flourishes in a good loamy soil, preferring it to remain moist throughout the summer. It can tolerate full sun or light shade and is particularly well-suited for thin woodlands. During its dormant period, this ornamental plant can endure temperatures as low as -15°C, although young growth in spring may be sensitive to late frosts.
One of the most captivating features of the Holodiscus discolor is its delightful fragrance reminiscent of meadowsweet. In addition to its beauty, this shrub possesses numerous medicinal properties. For centuries, a decoction of the leaves has been used to combat influenza, while the seeds have been regarded as a blood purifier. An infusion made from the plant has been known to aid in the treatment of smallpox, black measles, and chickenpox. The blossoms can be used to alleviate symptoms of diarrhea, and the inner bark is known for its tonic properties. Moreover, a poultice created from the leaves has been widely applied to soothe sore lips and feet, while a powder made from the dried leaves has been used as a dressing for sores. The bark of Holodiscus discolor can be dried, powdered, and mixed with oil to serve as a burn dressing. Additionally, an eyewash can be made from an infusion of this versatile plant.
Holodiscus discolor Cream Bush is a deciduous shrub that reaches heights of up to 5 meters. Its beautiful, lobbed leaves measure 5-9cm long and 4-7cm broad, displaying a juicy green shade when new. Adorning the branches are cascading clusters of white flowers, which give the shrub its common names. These sweet-smelling blossoms are followed by small, hairy fruits containing seeds that are light enough to be dispersed by the wind.
This plant boasts a fast growth rate and is hardy to zone 5. It blooms in July and bears ripe seeds by October. The flowers are hermaphrodite, attracting various insect pollinators. The Cream Bush can thrive in different soil types, including sandy, loamy, and clay soils, and can tolerate varied pH levels.
Holodiscus discolor Cream Bush, with its stunning appearance and numerous medicinal benefits, is a must-have for any garden or landscape. Enjoy the beauty and fragrance of this versatile shrub while reaping the rewards of its natural remedies. Experience the wonders of nature with Holodiscus discolor Cream Bush – your garden's newest treasure. For more information, visit http://plants.usda.gov.