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 = '5891'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Coreopsis lanceolata, also known as Lance Coreopsis or Lanceleaf Tickseed, is a beautiful native perennial found throughout the eastern and western United States, Canada, and Mexico. This plant produces striking yellow flowers in late summer, attracting honeybees and butterflies for its nectar and seeds. Considered an invasive species in Japan and China, it thrives in full sun and well-drained soil, making it an excellent choice for pollinator restoration. With little maintenance required, it can also naturalize to form large colonies. Its narrow, lance-shaped leaves lend it a unique appearance, while cultivars provide even more color options. Grow this Missouri native wildflower to enhance the natural beauty of your garden or landscape.