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 = '6567'
group by i.id
Looking for a beautiful and hardy grass that is native to North America? Look no further than Sorghastrum nutans, also known as Indiangrass or Yellow Indiangrass. This stunning warm season perennial grass can be found in prairies, glades, and open woods throughout Missouri, and was one of the dominant grasses of the tallgrass prairie that once covered the Midwest. It typically grows 3-5 feet tall, forming upright clumps of blue-green leaves that turn orange-yellow in the fall. In late summer, the grass sends up stiff stems topped with feathery, light brown flower panicles highlighted with yellow stamens. These panicles add interest throughout the winter, darkening to bronze/chestnut brown before fading to gray. Indiangrass is also the official state grass of both Oklahoma and South Carolina, and is prominent in tallgrass prairies alongside big bluestem, little bluestem, and switchgrass. Enhance your garden or landscape with the beauty of Indiangrass, a native grass that is both hardy and eye-catching.