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 = '1348'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours
Stratification: warm stratify for 60 days, cold stratify for 150 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: if water treatment does not allow seed to imbibe, sulfuric acid treatment is required
Introducing the Sambucus pubens Red Elderberry, also known as Scarlet Elderberry! This deciduous shrub is a stunning addition to any garden, with its shiny compound dark green leaves and pyramidal clusters of yellow-white flowers. The flowers bloom from May to June, adding a touch of beauty and fragrance to your outdoor space.
Growing to a height of 8-12 feet, the Red Elderberry has a somewhat sprawling habit that creates a natural and wild look. It is winter hardy and can thrive in USDA Zones 3 to 6 or 7, making it suitable for a wide range of climates. This shrub prefers moist, humusy, nutrient-rich, neutral to slightly acidic loams, although it is tolerant of various soil types.
One of the notable features of the Red Elderberry is its showy, edible fruit. The scarlet berries, about a quarter-inch in size, are not usually consumed raw by humans due to their sour taste. However, they can be cooked and used in the preparation of wine, jelly, and pies. These fruits are also highly attractive to wildlife, making your garden a haven for birds and butterflies.
Historically, the Red Elderberry was known as European red elder in Europe and Asia. In North America, a similar species known as Sambucus pubens, or American red elder, existed. However, many authorities have now grouped both of these red elders together under the name Sambucus racemosa.
Caring for the Red Elderberry is relatively low-maintenance. It prefers full sun to part shade and medium to wet watering conditions. Pruning can be done in late winter, with options to remove dead or weakened stems, shorten one-year-old stems, or cut some stems back to the ground for rejuvenation.
This versatile shrub has multiple uses in the garden. It can be used as a hedge or naturalized in areas where its spreading nature is appreciated. The Red Elderberry makes a beautiful accent shrub, with its deeply incised leaves, attractive flowers, and interesting fruits. It can also be planted in shrub borders, screens, backgrounds, or along streams and ponds.
With its stunning appearance and wildlife-friendly qualities, the Sambucus pubens Red Elderberry is a must-have for any garden. Don't miss the opportunity to add this beautiful shrub to your outdoor space!