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 = '697339'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, lightly mulch the seed bed.
Cosmos sulphureus, alternatively known as sulfur cosmos and yellow cosmos, is a plant native to Central America, Mexico, and northern South America. Its vibrant flowers bloom in shades of yellow, orange, and red, attracting a myriad of birds and butterflies, including the beloved monarch butterfly. Cultivated as a half-hardy annual, Cosmos sulphureus may continue to appear for several years through self-sowing. The plant is favored in Japan and Korea, where it is often seen flourishing in mass by roadsides, a reflection of an initiative by the Korean-Japanese botanist Woo Jang-choon. The plant prefers a soil pH between 6.0 and 8.5 and full sun exposure. Germination takes between 7 and 21 days under an optimal temperature of 75 degrees Fahrenheit with flowering beginning between 50 and 60 days after germination. Its resilience is proved by its drought tolerance after germination and rare susceptibility to insect or disease damage. This species possesses a variety of culinary and medicinal uses, enhancing its appeal and utility. Despite its allure, Cosmos sulphureus was declared invasive by the United States Southeast Exotic Pest Plant Council in 1996.