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 = '2408'
group by i.id
Embrace the breathtaking beauty of Cosmos bipinnatus, also known commonly as Garden Cosmos or Mexican Aster. This medium-sized flowering plant, native to Mexico, offers a captivating display of blossoms in various appealing hues such as pink, white, gold yellow, orange, red, and crimson. It's a preferred choice for temperate climate gardens by individuals who love to combine ornamental attractiveness with natural utility. Garden Cosmos not only attract butterflies and birds, but is also ideal for butterfly gardening and serving as a habitat for honey bees. Growing this plant is a walk in the park! It requires a sunny position and can flourish even in infertile and dry soils. The seeds typically germinate between 7-10 days at an optimal temperature of 75°F (24 °C), with flowering commencing 60-90 days post-germination. Enjoy a continuous bloom from early summer till frost, with the accentuated touch of delicate, feathery foliage. For a top-heavy plant, growing in groups will ensure the leaves interlock and provide support for each other. This half-hardy annual can grow rapidly and promises an enchanting display for your garden year after year.