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 = '4390'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 120 days, cold stratify for 120 days, ,
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: germination may be delayed until the following year
Oplopanax horridus, also known as Devil's Club or Devil's walking stick, is a large shrub found in the rainforests of the Pacific Northwest and on some islands in Lake Superior. It is recognized for its large palmate leaves and woody stems, covered in noxious and irritating spines. Many native North American tribes have used it medicinally for its pain-relieving properties, and in vitro studies have shown that extracts of Devil's Club inhibit tuberculosis microbes. The plant is sensitive to human impact and is slow-growing, taking many years to reach seed-bearing maturity. Devil's Club reproduces by forming clonal colonies through a layering process, and it is found in moist, dense forest habitats. The plant has been used ceremonially by some native tribes, and its charcoal has been used to make face paints. However, the consumption of an oral tea made from the plant is most common. It has been marketed as "Alaskan ginseng," but despite some morphological similarities, it is not a true ginseng.