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 = '698509'
group by i.id
Germination: seed may start to germinate in cold strat., sow seed 1/4" deep, tamp the soil, mulch the seed bed
Explore the wide world of nature with the intriguing Cinna arundinacea Stout, popularly known as Sweet Woodreed and Stout Woodreed. This perennial aquatic species is native to the Lower 48 and Canada, weaving a significant ecological web. Exhibiting a strict growth pattern with stems erect or ascending and nodes swollen or brittle, this plant radiates vitality with vibrant green foliage and inconspicuous green flowers. Hardy and resistant, it withstands fires and grows prolifically in both coarse and fine-textured soils. With a high C:N ratio and harboring no toxicity, this plant is safe and beneficial for various ecosystems. It blooms in summer, offering medium abundant fruit/seeds. Despite its low drought tolerance, this water-dependent species revels in areas with a minimum precipitation of 18 and frost-free days of at least 130. This long-lived, authentically North American plant, stands 4.9 feet tall at full maturity, braving temperatures as low as -33°F. Add nature's masterpieces to your space with Sweet Woodreed!