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 = '4067'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Asclepias syriaca, commonly known as common milkweed, is a tall, herbaceous perennial plant that is native to North America. It is a member of the milkweed family (Apocynaceae) and is known for its milky sap and its attractive pink to purple flowers. Common milkweed typically grows 3-5 feet tall, but can reach heights of up to 8 feet in favorable conditions. It has thick, oval leaves that are dark green on top and lighter green on the underside. The flowers are arranged in domed clusters and bloom from late spring to early summer. The flowers are a good source of nectar for butterflies and other pollinators.
Common milkweed is a valuable plant for the environment. It is a host plant for the monarch butterfly, and its seeds are eaten by birds and other wildlife. The plant also helps to control soil erosion and improve air quality.
In addition to its ecological benefits, common milkweed has also been used for medicinal purposes. The plant's milky sap has been used to treat a variety of ailments, including burns, rashes, and insect bites. The roots of the plant have been used to treat coughs, colds, and asthma.
Today, common milkweed is still used for a variety of purposes. It is grown as an ornamental plant, and its seeds are used to make a type of silk. The plant is also used in traditional medicine, and its extracts are being studied for their potential medicinal properties.