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
Cosmos bipinnatus, also known as the garden cosmos or Mexican aster, is a beautiful flowering plant native to Mexico. It is widely grown as an ornamental plant in temperate climate gardens, thanks to its vibrant and attractive flowers. The flowers of Cosmos bipinnatus have the ability to attract birds and butterflies, including the majestic Monarch butterfly. This plant is often included in butterfly gardens and pollinator habitats for honey bees.
Germinating within 7 to 10 days at an optimal temperature of 75 degrees Fahrenheit (24 °C), Cosmos bipinnatus begins to flower between 60 and 90 days after germination. With a rapid growth rate, this plant produces blooms from early summer until frost. The colors of its flowers range from shades of pink, white, gold yellow, orange, red, to crimson.
One of the notable features of Cosmos bipinnatus is its delicate and feathery foliage. It flourishes in dry and infertile soils, making it an easy plant to grow. While it thrives in a sunny and well-sheltered position, it can also tolerate partial shade.
Cosmos bipinnatus is considered a half-hardy annual, and its varieties and cultivars can self-sow, allowing the plant to reappear for several years. Some popular varieties of Cosmos bipinnatus include Sensation, Versailles, Sonata, and Daydream, each offering different heights and color variations.
When cultivating Cosmos bipinnatus, it is important to note that the plant prefers a soil pH between 6.0 and 8.5, reflecting its native alkaline habitat in Central America. Flowering is best in full sun, but it can tolerate partial shade. However, excessive rain can cause problems due to the fragile nature of its stems. Additionally, Cosmos bipinnatus does not handle droughts, strong winds, or cold temperatures well. Planting snails, slugs, and aphids may be attracted to Cosmos bipinnatus.
In conclusion, Cosmos bipinnatus is a versatile and attractive plant that can add beauty to any garden. Its ability to attract birds and butterflies, along with its vibrant colors and delicate foliage, make it a popular choice among gardeners. Whether you are starting a butterfly garden or simply want to bring more color to your landscape, Cosmos bipinnatus is a great option.