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 = '3729'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Angelica atropurpurea, hailing from North America's moist woodlands is a beautifully medicinal plant. Relished for its lush foliage, this perennial plant stands tall at 6 feet with an erect, sturdy stem that sways with shades of purple. The green-white umbrella-like flowers yield a depth of character, branching into 40 arms, each extending up to 8 inches wide. Remarkably, early American settlers found a sweet indulgence in this plant, boiling it down into candy and enriching their cakes with it. A unique culinary attribute of this plant is its celery-like flavor, allowing for a nutritious, flavorful snacking option. Its therapeutic qualities cannot be overlooked either - it was believed in Europe to be a powerful antidote to alcoholism. Further, Native American cultures revere the aromatic root of Angelica atropurpurea as a sacred purification herb. Interestingly, it's traditionally burned in healing ceremonies, carried in their medicine bags in Arkansas and utilized in both medicinal and ceremonial practices by Mvskoke Creek tribes. Its natural remedies cater to a range of issues, from back pain to stomach disorders. Unarguably fascinating, Angelica atropurpurea is a treasure chest of nature, full of unique flavor, medicinal value and vibrant aesthetics.