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 = '697270'
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: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/8" deep , tamp the soil, mulch the seed bed
Datura wrightii, also known as Sacred Datura or Sacred Thorn-apple, is a remarkable yet poisonous perennial plant and ornamental flower that is native to southwestern North America. It is classified as a deliriant and an anticholinergic and is sometimes used as a hallucinogen, though ingestion of any plant material can be fatal to humans, livestock, or pets. Datura wrightii is a vigorous herbaceous perennial that can grow from 30 cm to 1.5 m tall and wide. Its sweetly fragrant flowers are its most striking feature, as they are white trumpets up to 20 cm long with five narrow points spaced symmetrically around the rim. The plant blooms from April to October, with flowers opening in the morning and evening and closing during the heat of the day. Datura wrightii is found in northern Mexico and the adjoining U.S. states, as far north as southern Utah, in open land with well-drained soils. It is often planted as an ornamental, particularly in xeriscapes. While this plant has been historically used ceremonially and purportedly recreationally as a hallucinogen, it is highly toxic and dangerous to consume. Caution should be taken with any exposure or contact.