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 = '6179'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 180 days, cold stratify for 120 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
] The petioles are "rusty hairy" with grooves and sometimes wings, while the leaf margins are serrate. This shrub's autumn leaf colors range from bronze to red. Twigs range in color from reddish-brown to gray, with young twigs hairy and becoming smoother with age. The bark resembles that of the flowering dogwood, with a similar color range. Viburnum rufidulum blooms in April to May with creamy white flowers that are bisexual, with clusters as large as six inches wide. The fruits are purple or dark blue, edible drupes that mature in mid to late summer and reportedly taste like raisins, attracting birds. This plant is easily grown in average, dry to medium, well-drained loams in full sun to part shade, preferring light afternoon shade in the St. Louis area. It is a deciduous, suckering shrub or small tree typically growing 10-20' tall and known as the rusty black haw or southern black haw. Its glossy dark green leaves are ovate to obovate and turn reddish-purple in fall. Southern black haw is distinguished from the similar black haw by its rusty brown hairs and glossy green leaves, making it an excellent choice for ornamental purposes.