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 = '698607'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow 1/8" deep, mulch the seed bed, keep moist
Looking for a plant that will add beauty and interest to your garden while also attracting butterflies and birds? Look no further than Ratibida pinnata, also known as gray-head coneflower, yellow coneflower, and prairie coneflower. This hardy, native perennial can grow up to one meter tall and produces long stalks of vibrant yellow flowers with drooping petals surrounding a grayish-brown cone. The rough-haired, glandular leaves can reach up to 40 centimeters in length and are divided into several large lance-shaped or oval lobes. This plant grows well in prairies, on the margins of woods, and on roadsides, and is equally at home in both moist and dry habitats. It's not easily outcompeted by other plants, so it's a reliable choice for your garden. Add Ratibida pinnata to your landscape for a touch of prairie charm and natural beauty.