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 = '6563'
group by i.id
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: can be fall sown without stratification.
Introducing the majestic Sorghastrum nutans var. Holt Indiangrass, also known as Yellow Indiangrass. This North American prairie grass is a warm season Missouri native that was once a dominant grass of the tallgrass prairie. It grows 3-5 feet tall, forming upright clumps of slender blue-green leaves that turn orange-yellow in the fall. In late summer, the stiff, vertical flowering stems emerge and rise up to 6 feet tall, bearing narrow, feathery, light brown flower panicles highlighted with yellow stamens. These panicles mature to a bronze/chestnut brown in fall and continue to provide interest well into winter. Sorghastrum nutans var. Holt Indiangrass is perfect for prairies, glades, and open woods, and it's a favorite of birds and butterflies. Get this stunning grass and add a touch of the Midwest prairie to your landscape.