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 = '1420'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 120 days, cold stratify for 180 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Symphoricarpos orbiculatus, also known as Coralberry or Indian Currant, is a deciduous shrub native to North America and Central America. It belongs to the honeysuckle family and is characterized by its purplish-red fruit, yellow-white flowers with pink tints, and dull green or blue-green leaves. This shrub has a spreading habit with arching branches and can grow up to 5 feet tall. It is commonly used as a hedge or informal screen due to its tolerance of trimming. The extensive root system and ability to sucker freely make it suitable for soil stabilization. In open woods, fields, pastures, and thickets, Coralberry forms dense colonies and spreads by runners to create impenetrable thickets. It typically grows 2-5 feet tall and produces bell-shaped, white flowers with a pink tinge in summer, followed by clusters of round, coral-red berries in autumn. The berries persist through winter, adding color and interest to the landscape. Coralberry is also known for its smooth, dull green leaves and shredding bark on older wood. It is a good choice for woodland gardens and attracts wildlife. This shrub can be easily grown in a variety of soils and tolerates both full sun and part shade. It has no serious insect or disease problems, although mildew and leaf spot can occur in certain climates. Coralberry is a hardy plant that can withstand harsh conditions, making it suitable for erosion control on slopes. Overall, it is an attractive and versatile shrub that adds beauty and functionality to any garden or landscape.