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 = '700324'
group by i.id
Germination: Broadcast, drill or hydroseed on prepared seed bed.
Ensure robust and high-quality pasture growth with Fawn Tall Fescue, a proven performer since its development in Oregon in 1954. Sow this impressive crop at a rate of 25 lbs per acre to maximize your yield. This deep rooted bunchgrass is incredibly resilient, easily handling heavy traffic and displaying good heat tolerance for high temperatures. Apart from being visually attractive with its vibrant green color, it also brings rich deep soil nutrients to the surface. Fawn Tall Fescue has a special place as a cover crop when mixed with nitrogen-fixing legumes. Plus, it's virtually endophyte free making it safe and palatable for grazing animals. Ideal for permanent cover in vineyards, orchards, or no-till irrigated settings, it works harmoniously with other perennial clovers - the perfect sustainable solution for today’s responsible agriculture. Give your soil, crops and farm ecosystem a boost with the multiple benefits of Fawn Tall Fescue. Not only is it splendidly low-maintenance, but with an ability to grow up to 4.5 ft., it provides a good yield, making it both a practical and economic choice. Choose Fawn Tall Fescue for a greener and richer pasture.