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 = '1296'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Other: can be fall sown without stratification.| if boiling water treatment does not allow seed to imbibe, sulfuric acid treatment is required
Introducing Rhus trilobata Skunk Brush Sumac, also known as sourberry, skunkbush, and three-leaf sumac. This shrub is native to the western half of Canada and the United States, with a range extending south into northern Mexico. From deserts to mountain peaks up to 7,000 feet in elevation, this versatile plant is a popular feature of many North American landscapes. Skunk bush was employed by several native North American tribes for its astringent qualities and has been used to treat a variety of ailments. The fruit is analgesic, astringent, and stomachic, and has been used to treat stomach problems, grippe, and toothaches. The leaves and bark also have various medicinal properties, from treating itches and colds to inducing impotency as a method of contraception. With its dark green leaves that may turn red and yellow in the fall, Rhus trilobata is a striking addition to any garden or landscape. While this plant should be used with caution due to its potentially toxic nature, it can be a valuable natural remedy when used under the supervision of a qualified practitioner. Learn more about Rhus trilobata on our website.