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 = '699055'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Seed needs warm temperatures after sowing to germinate (75 degrees F +)
Cucurbita foetidissima, also known as Buffalo Gourd, Missouri Gourd, and Prairie Gourd, is a tuberous plant found in the southwestern United States and northern Mexico. It is well-adapted to desert environments and requires little water, making it a great crop for arid and semiarid lands. The plant contains high amounts of protein, carbohydrates, and abundant oil, which can be used for biofuel production. The fruit can be eaten cooked, and the seeds can be ground into a powder for use in soups or as a thickening agent. The fleshy tap root can be used as a sweetener or for making puddings like tapioca. The buffalo gourd also has industrial uses such as water paints, paper coating, adhesives, and textile sizing. This plant has been used for centuries by Native American cultures for its soap and shampoo-like qualities. The buffalo gourd is a hardy plant that can be grown in sandy loam soils with good drainage and germinates best at temperatures between 15 °C and 37 °C. This adaptable plant offers a range of uses making it a valuable addition to any garden or farm.