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 = '697337'
group by i.id
Looking for a vibrant and easy-to-grow addition to your garden? Look no further than Coreopsis tinctoria, also known as Plains coreopsis, garden tickseed, golden tickseed, or calliopsis. This annual forb is native to much of North America and is a favorite of bees and other pollinators. Growing quickly, Coreopsis tinctoria plants reach heights of 12 to 40 inches and produce numerous, brilliant yellow flowers with maroon or brown centers from mid-summer to early fall. Not only is this plant beautiful, but it is also historically significant - the Zuni people use its blossoms to make a mahogany red dye for yarn. Coreopsis tinctoria is easily grown in many types of soil and prefers a sunny position. Once established, it is drought-resistant and requires little maintenance. Use it as a vibrant addition to your garden, as a native plant for wildlife gardens and natural landscaping, or even harvest the dried plant to make a delicious and nutritious tea. Don't miss out on this easy-to-grow and stunning plant!