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 = '5675'
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.
Trifolium pratense 'Medium' or Medium Red Clover is a popular cultivar group known for its impressive nitrogen fixation capabilities, making it a valuable crop for improving soil fertility. This herbaceous perennial plant, growing up to 80 cm tall, features characteristic trifoliate leaves with pale crescents in their outer half and produces dark pink flowers in dense inflorescences. Not only is it an excellent fodder crop, but red clover also serves as a sweet-tasting herbal tea ingredient and is used in traditional medicine due to its antispasmodic, expectorant, and anti-inflammatory properties. However, caution should be taken while using red clover as it may cause various adverse effects like rash, headache, and nausea. Its phytoestrogen content also makes it contraindicated for some individuals with certain health conditions. Nonetheless, Trifolium pratense can be a beautiful addition to gardens, serving as the national flower of Denmark and the state flower of Vermont. It is a plant worth considering for horticultural or agricultural purposes, particularly in zones 3-6.