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 = '700321'
group by i.id
Germination: Broadcast, drill or hydroseed on prepared seed bed.
Other: Seeding Rate: 6-10 lbs per acre alone, 2-4 lbs per acre in a mix.
Looking for an easy-to-grow crop that is excellent for both soil improvement and animal fodder? Look no further than Trifolium pratense 'Mammoth' Red Clover! Mammoth red clover grows taller than medium red clover and matures approximately 10 to 14 days later. Because of its coarse stems, Mammoth is typically not used for hay or pasture since it has coarse stems, but mostly grown as a green manure crop. This short-lived perennial is native to Europe and western Asia but has been naturalized in many other regions, including the Americas and Australasia. It produces bright pink flowers that are a familiar sight in pastures, and fixes nitrogen in the soil. Red Clover is also commonly used to make a sweet herbal tea and has traditional uses in Indian medicine as an anti-inflammatory and expectorant agent. Although medicinal quantities may cause adverse side effects, dietary amounts are safe. It is adapted to a range of environments and is a popular choice for farmers looking to improve soil quality. With so many benefits, it's not hard to see why the Mammoth Red Clover is a favorite of gardeners and farmers alike!