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 = '700450'
group by i.id
Germination: sow seed 1/8" deep, tamp the soil, mulch the seed bed
Looking to add some color to your garden? Look no further than Ipomoea purpurea mix tall morning-glory! This species, native to Mexico and Central America, entwines itself around structures and grows to a height of 6-10 ft. The heart-shaped leaves and trumpet-shaped flowers range in color from blue to purple or white, and are 3-6 centimeters in diameter. While the plant thrives in moist and rich soil, it can be found growing in a wide range of soil types and is naturalized in warm temperate and subtropical regions of the world. In addition to its ornamental value, the triangular seeds of this mix have a history of use as a psychedelic and contain LSA. The seed is also used medicinally in the treatment of oedema, oliguria, ascariasis, and constipation. If you're looking to plant these beauties, pre-soak the seed or scarify it and sow in a greenhouse in early spring. The seed usually germinates in 1-3 weeks at 70°F. Plants are extremely resentful of root disturbance, so pot them up almost as soon as they germinate and grow them on fast in the greenhouse before planting them out into their permanent positions after the last expected frosts. These Morning-glories are perfect for landscaping purposes, whether planted on an arbor or in a container or used as a specimen. They require a fertile, well-drained loam in a sunny position and, while not very frost hardy, can be grown outdoors as a tender annual in temperate zones.