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 = '700348'
group by i.id
Scarification: Carefully drill a hole in each seed coat. Drill all the way through the seed coat but stop before drilling too far into the embryo. Soak in water for 12 hours.
Stratification: none required
Germination: sow 1-2" deep, tamp the soil, mulch the seed bed
Looking for a new way to experience vivid dreams and connect with the spirit world? Look no further than Entada rheedii, also known as the African Dream Herb, Cacoon Vine, or Snuff Box Sea Bean. This woody liana or climber is widely distributed throughout tropical and subtropical countries, and has been used for centuries in African traditional medicine to induce powerful dreams. The seeds, which can survive lengthy periods of immersion in seawater thanks to their thick and durable seed coat, can either be consumed directly or smoked with other herbs like tobacco just before sleep. But the benefits don't stop there - the plant also has topical applications and even makes for beautiful jewelry and good-luck charms. So whether you're looking to explore the spiritual realm or simply want to try something new, Entada rheedii is definitely worth considering.