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 = '597'
group by i.id
Austria, Belgium, Bulgaria, Canada, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovenia, Spain, Sweden
Scarification: none required
Stratification: none required
Germination: Sow seed in Spring, lightly cover with soil.
Other: Will germinate in 3-6 weeks at 60 degrees Farenheit
Datura stramonium, also known as Jimson Weed, Devil's Trumpet, Thorn Apple, and Moonflower, is a common weed in the nightshade family. It has a history of use in traditional medicine for its pain-relieving and healing properties, but its highly toxic nature requires extreme caution. All parts of the plant contain powerful mind-altering compounds that have been used to calm schizophrenic patients, but the difference between a medicinal and toxic dose is very small. The plant is widely spread across warm and moderate regions of the world and can be found along roadsides and in garbage dumps. The fragrant flowers, which emit a pleasant fragrance at night, are trumpet-shaped and fed upon by nocturnal moths. The plant has been used in sacred ceremonies by various indigenous people across the Americas to achieve intense hallucinations and visions. Careful use and supervision by a qualified practitioner are critical to minimize harm.