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 = '698769'
group by i.id
Germination: Broadcast, drill or hydroseed on prepared seed bed.
Looking for a deep-rooted, drought-tolerant grass that can survive at altitudes of up to 2,000 meters? Look no further than Cenchrus ciliaris, also known as African foxtail grass or Buffel grass. This species, native to most of Africa and southern Asia, is considered a great forage grass in its home range. Despite its benefits, the grass has become an invasive species in many places where it has been introduced, including Australia, South America, Central America, and the southwestern United States. Buffel grass is known for its ability to grow quickly and compete successfully against other vegetation, including native species. While it may be a great option for erosion control and as a source of livestock forage, management is essential to prevent its negative impacts.