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 = '5514'
group by i.id
Scarification: soak in warm water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a unique plant native to North America? Look no further than Glycyrrhiza lepidota, also known as American Licorice or Wild Licorice. This plant, part of the pea/bean family, can be found from central Canada to California, Texas and Virginia. It prefers moist, sandy soil and can grow up to 1 meter tall. The long, fleshy roots are edible raw or cooked and contain glycyrrhizin which is 50 times sweeter than sugar! Traditionally used by Native American tribes for medicinal purposes, all parts of the plant are considered to have medicinal properties but the roots are the most active. American Licorice is also a pioneer species that can be used to revegetate bare or disturbed ground. With a market for both medicinal purposes and flavoring, American Licorice is a unique plant with a variety of uses.