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 = '4107'
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
Discover the delightful charm of the Willow-leaved Magnolia, also known as Magnolia salicifolia or Anise Magnolia. Originally native to Japan, this small deciduous tree or shrub thrives in rocky, granite soil along streams. Reaching heights of 25 ft, the tree exhibits an architectural form ranging from a narrow to broad pyramid. One of its most striking features is its narrow lanceolate leaves with whitened undersides, emanating an enticing anise or lemon-verbena aroma when crushed. In spring, before the leaves emerge, fragrant white flowers bloom. These captivating 10 cm-wide blossoms consist of six petals. The tree also produces 5-7.5 cm long fruit, which initially appears rose-pink and fades to dull brown, containing striking scarlet seeds. Thriving in sunshine or part shade, the Anise Magnolia prefers moist, acidic soils. This hardy tree or shrub is adaptable to USDA Zone 4. Anise Magnolia is native to the islands of Honshu, Shikoku, and Kyushu in Japan, and are available to add a touch of exotic elegance to your garden.