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 = '842'
group by i.id
Germination: spring sow indoors before last frost or direct sow outdoors after the threat of frost is over
Other: Research Needed
Introducing the beautiful and vibrant Lychnis chalcedonica, a flowering plant in the family Caryophyllaceae. Also known as Burning Love, Dusky Salmon, Flower of Bristol, Jerusalem Cross, Maltese Cross and Nonesuch, this herbaceous perennial plant can grow up to 100cm tall with unbranched stems and opposite, broad lanceolate leaves. The bright red flowers are produced in clusters of 10-50 together, each with a deeply five-lobed corolla, creating a shape similar to the Maltese Cross to which it owes its name. This plant is easy to cultivate and popular in gardens, offering numerous cultivars with varying flower colours from bright red, to orange-red, pink or white. It grows best in partial to full sun and well-drained soil with constant moisture supply. The double flowered cultivars are propagated by division. Be sure to remove faded flowers to extend the flowering period. While it is short-lived in poorly drained soil, Lychnis chalcedonica can become naturalised or even invasive if plants are allowed to set seed, so take care with your planting. Thomas Jefferson is even known to have sowed this plant at his home, Monticello!