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 = '698583'
group by i.id
If you're looking for a stand-out addition to your garden, look no further than Muhlenbergia capillaris, also known as Pink Muhlygrass. This hedge-like perennial grows up to 3 feet tall and wide, boasting green foliage and pink, feathery flowers during the fall months. Not only is it aesthetically pleasing, but it's also low maintenance and disease-resistant making it easy to care for. This warm-season grass is native to eastern North America and is perfect for ornamental gardening or farming. It was even voted the 2012 plant of the year by the Garden Club of America. So, whether you're a seasoned gardener or just starting out, Pink Muhlygrass is sure to add a touch of beauty to your landscape.