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 = '407'
group by i.id
Looking for a low-maintenance, evergreen groundcover with stunning white flowers? Look no further than Cerastium tomentosum, also known as Snow-in-Summer. This herbaceous perennial features silvery-grey foliage and star-like white flowers that bloom not only in summer but at other times of the year as well. One plant can quickly cover a square yard, making it an excellent choice for filling in areas of your garden. While it is native to alpine regions of Europe, it has become popular as a cultivated ornamental and can be found in gardens worldwide. And don't worry about having a green thumb - Cerastium tomentosum is easy to take care of, though be aware that it can be invasive. Whether on a rock garden or as a wall plant, this beautiful plant will add a touch of elegance to any landscape.