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 = '5877'
group by i.id
Chelidonium majus, commonly known as Greater Celandine, Swallow Wort or Celandine, is a fast-growing herbaceous perennial plant that can reach a height of up to 120 cm. The lobed and crenate leaves can grow up to 30 cm in length, and the plant produces beautiful yellow flowers with four petals from late spring to summer. The plant self-sows freely and can become an aggressive invasive species in natural areas, so control through pulling or spraying before seed dispersal is recommended. Chelidonium majus is hardy and can grow in a variety of soils, from light to heavy. It prefers moist soil and can grow in full shade or semi-shade. This herb has been used for its medicinal properties for centuries and is believed to have anti-inflammatory and pain relieving effects. However, it is important to consult a healthcare professional before using it. If you are looking for a low-maintenance and beautiful addition to your garden, Chelidonium majus might just be the perfect plant for you.