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 = '698424'
group by i.id
Germination: Sow seed in Spring, lightly cover with soil.
Discover the benefits of Avena sativa, more commonly known as oat. This species of cereal grain is farmed for its nutrient-rich seed, which is the key ingredient in oatmeal and rolled oats. Regular consumption of oats is linked to lower blood cholesterol levels. The oat grain flourishes in moderately fertile soil under full sun exposure. It thrives in poor dry soil and cool moist conditions, making it an easily grown crop. The seed ripens late summer, can be harvested and dried, and then stored for several years. Known for its creamy flavor, the grain can be utilized in both savory and sweet dishes. While oats are primarily used for human consumption, specially in breakfast cereals like porridge, they are also commonly used as livestock feed. This hardy crop holds an edibility rating and is noted for its simple cultivation process. Interestingly, oat also possesses medicinal properties, aiding in restoring vigour after serious illnesses and increasing stamina. Experience the versatility and benefits of the common oat.