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 = '447'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Looking for a new addition to your garden? Meet Feverfew - a traditional medicinal herb that also makes a lovely ornament. Known by its synonyms Chrysanthemum parthenium and Pyrethrum parthenium, this plant will grow into a small, citrus-scented bush covered in flowers resembling daisies. It thrives in any kind of soil and can even be grown in walls. Feverfew is a short-lived perennial that usually self-sows prolifically, making it a great addition to any garden. Medicinally, it has gained a good reputation in the treatment of certain types of migraine headaches and rheumatism, and is used as an anti-inflammatory, antispasmodic, sedative, and more. Not just great for the garden, the dried flowers are also used as a flavouring in cooking certain pastries and a tea can be made from the dried flowers. Try growing Feverfew in your garden for its medicinal properties and visually pleasing flowers!