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 = '698671'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1" deep, keep moist, mulch the seed bed
Other: Minimum soil temp should be 60F or 16C before sowing.
Vigna unguiculata, commonly known as Cowpea or Blackeyed Pea, is an annual legume that thrives in sandy soil and low rainfall. It is a valuable crop in semi-arid regions across Africa and other countries due to its ability to tolerate harsh conditions. Cowpea requires very few inputs, as its root nodules fix atmospheric nitrogen, making it a suitable crop for resource-poor farmers and for intercropping with other crops.
The whole plant is used as forage for animals, particularly for cattle feed, which is likely why it is called Cowpea. There are four recognized subspecies of Cowpea, three of which are cultivated. The species exhibits a high level of morphological diversity, with variations in size, shape, and structure. The crop can be erect, semi-erect, or climbing.
Cowpeas are primarily grown for their protein-rich seeds, but the leaves and immature seed pods can also be consumed. They are known by various common names such as Blackeyed Pea, Southern Pea, Yardlong Bean, Catjang, and Crowder Pea. Cowpeas were domesticated in Africa and are one of the oldest cultivated crops. They were later domesticated in Asia before spreading to Europe and the Americas.
The seeds are commonly cooked and used in stews, curries, or ground into flour or paste. Most of the world's cowpeas are grown in Africa, particularly in Nigeria and Niger, which account for 66% of global production. Cowpeas are cultivated on approximately 12.5 million hectares, with a worldwide production of 3 million tonnes. They are consumed by 200 million people on a daily basis. However, insect infestation poses a significant challenge to cowpea production, often resulting in yield losses of over 90%. The legume pod borer and the cowpea weevil are the main pests affecting cowpeas.
Overall, Cowpea is a versatile and resilient crop that provides a vital source of protein and sustenance for many individuals in challenging growing conditions.