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 = '698754'
group by i.id
Scarification: let stand in tepid water for 12 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a versatile plant that is both ornamental and medicinal? Look no further than Senna alata, also known as Emperor's Candlesticks and Candelabra Bush. Native to Mexico, this stunning shrub is easy to grow from seed and can be found in diverse habitats. With leaves that close in the dark and an inflorescence that looks like a yellow candle, it's easy to see why this plant is so popular among gardeners. But that's not all - Senna alata is also highly prized for its medicinal properties, including its effectiveness in treating ringworm and other fungal infections of the skin. The leaves are ground to create a paste that is then mixed with vegetable oil and applied to the affected area several times per day. With its active ingredients, such as chrysophanic acid and anthraquinone, this plant also has a well-proven laxative effect. Whether you're looking for a stunning addition to your garden or a natural remedy for common skin ailments, Senna alata is the perfect choice. Grow some today!