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 = '700404'
group by i.id
Germination: Sow seed in spring when ground is warm 1/4" deep , keep moist
Looking for a versatile herb with numerous health benefits? Look no further than Mentha x piperita Peppermint. This hybrid mint, a cross between watermint and spearmint, is now widely cultivated across the world. Its leaves and flowering tops can be used to soothe or treat symptoms such as nausea, vomiting, indigestion, irritable bowel, and bloating. Peppermint oil has also been shown to be effective short-term treatment for irritable bowel syndrome, and may act as an antispasmodic, carminative, cholagogue, and secretolytic. In addition to its medicinal uses, peppermint is the oldest and most popular flavour of mint-flavoured confectionery, and is often used in tea, ice cream, chewing gum, and toothpaste. Peppermint flowers are also a magnet for honey bees, producing a light, pleasant honey. Give Mentha x piperita Peppermint a try and experience all of its wonderful benefits for yourself.