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 = '6442'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Introducing Calamagrostis canadensis, also known as Bluejoint, Bluejoint Reedgrass, Canadian Reedgrass, Marsh Pinegrass, Marsh Reedgrass, and Meadow Pinegrass. This tough perennial grass grows in clumps that can reach 3-5 feet in height, with many slender stems topped by large, nodding, branched inflorescences. The inflorescence starts out purple and later turns tan. Bluejoint grass remains upright even in winter, making it an ideal addition to any landscape. This grass is known for its soil stabilization properties in wet areas and is often one of the first plants to reestablish on oil spill sites. Livestock and wild grazing animals find it palatable, making it a great choice for pastures. However, be aware that Bluejoint grass can compete with conifers in restoration sites. Learn more about this versatile and valuable grass at plants.usda.gov.