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 = '802'
group by i.id
Scarification: Soak Seeds 12 hours before planting.
Stratification: none required
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Sweet Pea, also known as Lathyrus odoratus, is a beautifully fragrant flowering plant that has long been a favorite of gardeners. With large clusters of colorful flowers in blue, pink, purple, red, or white, this easily cultivated annual plant thrives in cooler climates but can also grow in hotter areas if kept cool by mulching around its base. To ensure maximum blooming, it is important to water it during the hot months and pick off dead flowers. The plant is native to the eastern Mediterranean region and an essential oil extracted from its flowers is used in perfumery. The sweet pea has a rich horticultural history, having been cross-bred and developed by Scottish nurseryman Henry Eckford in the late 19th century. Today, there are over 50 cultivars that have gained the Royal Horticultural Society's Award of Garden Merit. Though the sweet pea may suffer from common pests such as aphids and is susceptible to mildew, it remains a popular choice for private enjoyment or for exhibition and the floristry trade.