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 = '700417'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Introducing Lobelia inflata, commonly known as Indian tobacco or puke weed. This herbaceous plant is native to the eastern North American region, extending from southeastern Canada to Alabama and west to Kansas in the United States. It is an annual or biennial plant, growing up to 24 inches tall, characterized by stems covered in tiny hairs.
Historically, Native American tribes have used Lobelia inflata for medicinal purposes, including as an entheogenic, and to aid respiratory and muscle disorders. Traditionally, the plant was burned as a natural insecticide against gnats by the Cherokee tribe and was also used as a ceremonial medicine.
Lobelia inflata continues to be used for medicinal purposes today, which testifies to its critical role in traditional medicine. However, its use is currently regulated due to adverse effects which can include serious side effects, such as nausea, rapid heartbeat, and even coma or death. Medicinal use should always be under the supervision of a qualified practitioner.
Known for its easy propagation, this beneficial plant germinates within two weeks when its seeds are sown in spring or autumn. Delight in the experience of growing your own Indian tobacco or puke weed.