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 = '856'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 120 days
Germination: can be sown outdoors in the fall for spring germination, sow seed 1/2" deep, keep moist, mulch the seed bed, remove mulch upon germination
The Loebner Magnolia, a beautiful deciduous hybrid magnolia, is a favorite among garden enthusiasts because of its fragrant, star-like white flowers that bloom in early spring. This strong-growing plant has a rounded crown and grows up to 30 feet tall, making it perfect for lawns or multi-trunked forms. The deep pink buds open up into informal strap-like tepals with pale shell pink upper surfaces and darker pink-purple lower ones. This hybrid cultivar is hardy to USDA Zone 4 and prefers moist, well-drained soil in full sun to part shade. It is a cross between Magnolia kobus and Magnolia stellata and is among one of the most beautiful magnolias, according to plant expert Michael Dirr. It may even flower on very young plants, making it a great addition to any garden. Order now and enjoy the Loebner Magnolia's sweet fragrance and stunning flowers.