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 = '782'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: seed may benefit from a 3 month cold stratification
Knautia arvensis Blue Buttons, also known as Field Scabiosa or Field Scabious, is a hardy perennial plant that produces delicate and stunning blue, pinky-blue, lilac, or lavenderish flowers atop 3-foot stems. This wildflower is native to meadows and grassy hills, particularly on limestone, and is perfect for wild gardens. Its roots and flowers have been used for centuries as a natural astringent and diuretic, and an infusion can be used as a blood purifier or externally for wounds and bruises. It is also a food source for the Marsh Fritillary and Narrow-bordered Bee Hawk-moth. This stunning plant thrives in grassy places and dry soils, and is easy to grow. Add some natural beauty to your garden with Knautia arvensis Blue Buttons.