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 = '697790'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required| cold stratify for 30 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: Germination should occur between 30-60 days.
Looking for a unique and eye-catching addition to your garden? Look no further than Magnolia delavayi, also known as the Chinese Evergreen Magnolia or Delavay's Magnolia. This small evergreen tree boasts beautiful oblong-ovate leaves and fragrant cup-shaped flowers with creamy white to pink petals that bloom from July to August. While uncommon, Magnolia delavayi is increasing in popularity and cultivation, particularly with the recent rise in popularity of a red-flowered form. Plus, as the city tree of Chongqing, it's sure to add a touch of exotic elegance to your outdoor space. Don't miss out on the chance to add Magnolia delavayi to your garden!