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 = '697614'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: stratification improves germination, but is not required
Asclepias speciosa, commonly known as Showy Milkweed, is an eye-catching perennial plant in the dogbane family that is native to the western half of North America. The plant produces hirsute, pale pink through pinkish-purple flowers in dense umbellate cymes. The showy milkweed is a monarch butterfly food and habitat plant, and it also attracts the red-belted clearwing moth. The plant has edible parts, including flower buds, young shoots and leaves, immature seed pods, and raw seeds. The latex of the plant has been used as a cure for warts, skin sores, cuts, and ringworm, and can be applied once a day for a few weeks for the best results. The plant prefers a well-drained light rich or peaty soil and a sunny position. It is closely related to A. purpurascens, and its roots can spread freely when in favorable conditions. Showy Milkweed is a very ornamental plant with tough fibres obtained from the bark used in twine, coarse cloth, paper, and other things. The seed floss can be used to stuff pillows or mixed with other fibers to make cloth. It can also be utilized as a Kapok substitute and has been used to mop up oil spills at sea. Asclepias speciosa is hardy to US zone 3-9 and flowers from May through September.