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 = '5978'
group by i.id
Germination: Broadcast, drill or hydroseed. Surface sow and keep moist, mulch the seed bed
Introducing Elymus canadensis, also known as Canada Wild Rye, a native species of grass found throughout North America. It can be found in habitats such as riparian woodlands, forests, sand dunes, and prairies. This perennial bunchgrass can grow up to one and a half meters and is easy to cultivate in most soils with a preference for sandy soil and sunny conditions. Elymus canadensis has a shallow, fine root network and is a facultative mycotroph. It's used for stabilizing eroded areas and vegetating metal-rich soils in mines. This plant is also interesting genetically, reproducing mainly through self-pollination while being able to cross-pollinate, providing new species that could contribute to novel crops. Studies show how Elymus canadensis could help promote disease resistance in barley and improve crop quality through its high molecular weight glutenin subunit allele. Its symbiotic relationship with endophytic fungi may have aided in its successful evolution and could possibly improve the success of agricultural crops. Canada wildrye is not just beneficial to crop research; it provides a habitat for many bird and small mammal species.