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 = '142'
group by i.id
Germination: requires light for germination, surface sow and keep moist
Achillea millefolium, commonly known as Common Yarrow or Plumajillo, is a herbaceous perennial plant that can grow up to 3 ft tall. This flowering plant is native to temperate regions of the Northern Hemisphere in Asia, Europe, and North America. Common yarrow prefers well-drained soil in full sun and can be grown in less ideal conditions. It has a strong, sweet scent, similar to that of chrysanthemums. The plant has a long history of use in herbal medicine, as well as a food source. It combines well with other herbs like Elder and Peppermint for treating colds and influenza. Common yarrow is frequently found in butterfly gardens and is a common herb of both wet and dry areas, such as roadsides, meadows, fields, and coastal places. It is also cultivated as an ornamental plant and is a frequent component of drought-tolerant and wildlife gardens. Several cultivars of this species with specific 'improved' qualities have also gained recognition. Its essential oil contains chemicals called proazulenes and is known to kill mosquito larvae.