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 = '698321'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: surface sow and keep moist, requires light for germination
Adorn your garden with the delicate beauty of Campanula rotundifolia, also known as the Harebell or the Bluebell Bellflower. This splendid wildflower, native to North America’s semi-shaded woods and dry grasslands, stands about one foot tall. Blooming from June to September, its clusters of deep bluish-purple, bell-shaped flowers are a favorite of butterflies. Despite its fragility, the Harebell thrives in poor dry soils, rocky cliffs, gravel, sand, and woodland and makes a fine addition to your rock garden. It's not only famous for its beauty; it is also notable in literature, featured in the works of Shakespeare, Rossetti, and Dickinson. Known to have once been used to produce blue dye for Scottish tartans, this wildflower is well suited to chalk and limestone soils, hosting a wide array of insect life. Palest blue flowers nod atop slender stems from July to September, mingling enchantingly with warm summer breezes. Also known as Scottish Bluebell, The Devils Bell, The Fairies Thimble, and Witches’ Thimbles, this delightfully versatile plant does well in rocky soils and crevices, effortlessly spreading its charm in your landscape.