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 = '1369'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil and keep moist.
Serratula tinctoria, also known as Dyer's Plumeless Saw-wort or Sawwort, is a stunning perennial plant native to Europe, North Africa, and Siberia. Growing up to one meter tall, this plant features beautiful tubular reddish-purple flowers in small terminal clusters. In addition to its aesthetic qualities, Serratula tinctoria is a source of high-quality yellow dye that is extremely durable. As a herbal preparation, this plant is also believed to support the healing of ruptures and wounds. It thrives in moist soil and can be grown in full sun to part shade. You can now introduce the beauty and practicality of Serratula tinctoria to your garden. Order your plants today and enjoy their stunning display and practical applications.