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 = '5831'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Pimpinella anisum, also known as Common Anise or Burnet, is a herbaceous plant that is native to Southwest Asia and the eastern Mediterranean region. Its delicious flavor is similar to star anise, fennel and licorice, making it an excellent addition to a range of dishes and beverages. This annual plant thrives in light, fertile, well-drained soil and should be planted as soon as the ground warms up in the spring. The taproot prevents successful transplantation of the plant, so it's best to start in its final position. The anethole-rich essential oil yielded by distillation is praised in Middle Eastern countries, where it is used to make a refreshing hot tea called yansoon. With its sweet aniseed-flavored leaves, Pimpinella anisum is a great choice for salads, puddings, and soups. Anise has been used for centuries in traditional herbal medicine for its carminative effect, reducing flatulence. It is also thought to aid digestion, help with menstrual cramps and even stimulate desire. A versatile plant with a rich history, Pimpinella anisum is an excellent choice for your garden or cuisine.