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 = '698840'
group by i.id
Scarification: soak in warm water, let stand in water for 12 hours
Stratification: none required
Germination: surface sow and keep moist, tamp the soil, requires light for germination
Hyoscyamus niger, also known as Black Henbane or Stinking Nightshade, is a poisonous plant originally from Eurasia that is cultivated globally for medicinal purposes. It has been historically used for its psychoactive properties, including visual hallucinations and a sensation of flight, and as an anaesthetic potion. Henbane has been documented to bring unquiet sleep and was an ingredient in gruit, a beer flavouring. It is used in traditional herbal medicine for various ailments, ranging from rheumatism to stomach pain. However, the dosage has to be carefully estimated due to the high toxicity of the plant. The ingestion of henbane can lead to hallucinations, dilated pupils, restlessness, and ataxia. Although the plant is toxic to many animals, including wild animals, fish, and birds, pigs are immune to henbane toxicity, and the larvae of some moth species can consume it. While henbane was once confused for fat hen, a member of the spinach family, it is crucial not to consume the plant due to its high toxicity.