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 = '698841'
group by i.id
Scarification: Pour boiling water over seed , let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil
Other: Germination should occur between 30-60 days.
Indigofera tinctoria, also known as True Indigo, is a historic plant that has been used for centuries as a source of natural dye. Although its native habitat is unknown, it has been naturalized to tropical and temperate regions of Asia and Africa. While synthetic dyes have become more popular in recent years, there is still a market for dye derived from I. tinctoria, which is marketed as a natural coloring. Not only is this plant useful for dyeing purposes, but it is also a great soil-improving groundcover. If you're interested in learning more about Indigofera tinctoria, check out http://plants.usda.gov for additional information. Bring a little bit of history into your garden with True Indigo!