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 = '5140'
group by i.id
Germination: surface sow and keep moist, requires light for germination
Cichorium intybus, commonly known as chicory, is a perennial herbaceous plant belonging to the dandelion family. This plant is cultivated for its leaves, which are typically used in salads, and roots, which are used as a coffee substitute and food additive. Chicory root is especially important as a source of inulin, a starch that cannot be digested by humans but is ideal for diabetics. The leaves are often blanched to reduce bitterness and are commonly used in winter salads. The root can be boiled and used as a vegetable or roasted to add flavor to stouts. Chicory is also grown as a forage crop for livestock. Common chicory is found in Europe and has become naturalized in North America, China, and Australia. With its many culinary and medicinal uses, chicory is a versatile and valuable addition to any garden or kitchen.