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 = '1538'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: surface sow and keep moist, requires light for germination
Introducing the Campanula lactiflora Milky Bellflower! With beautiful bell-shaped pale lavender-blue flowers that bloom for an unusually long time in the summer and repeat in the fall, this plant is a must-have for your garden. It is easily grown in most soils and is very tolerant, even thriving in unkempt grassy areas. This plant is compact and tidy compared to other cultivars of its species and does not attract deer or rabbits. Keep it moist and cut back to promote fall rebloom. It's an erect, dwarf plant that grows 10-18" tall and self-seeds under the right conditions. Don't miss out on this exceptional addition to your garden! Visit our website for more information.