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 = '247'
group by i.id
Germination: sow seed 1/16" deep, tamp the soil, mulch the seed bed
Asclepias incarnata, also known as Swamp Milkweed, is a beautiful addition to any garden. This herbaceous perennial plant grows up to 4 ft tall from thick, fleshy, white roots and emerges in late spring. It produces attractive narrow, lance-shaped leaves that are 3-6 inches long with sharp tip ends. The plant produces small, fragrant, pink to mauve (sometimes white) colored flowers in rounded umbels during early to mid-summer, which attract pollinators with nectar, including the monarch butterfly. The flowers are followed by adorable pods that children love, which are edible when cooked. In fact, the young shoots can be eaten cooked and used as an asparagus substitute, and tips of older shoots are cooked like spinach. The young seed pods, harvested when they're between 1-2 inches long, have a pea-like flavor and are very appetizing. Although Swamp Milkweed has sap containing toxic chemicals, it repels insects and other herbivorous animals. The plant prefers moisture retentive to damp soils in full sun to partial shade and is typically found growing wild near the edges of ponds, lakes, streams, and low areas—or along ditches. It's also cultivated frequently and a number of cultivars are available. They are used especially in gardens designed to attract butterflies. With its stunning display of flowers and its attraction to pollinators, Asclepias incarnata is a must-have addition to any garden or landscape.