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 = '700220'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: Needs heat and moisture to germinate, don't let the soil dry out.
Other: Seed germination is slow, usually taking between 6 to 16 months to germinate.
Bismarckia nobilis 'Silver' Bismarck Palm, also known as Silver Bismarck Palm, is a stunning ornamental plant that can add a touch of exoticness to any landscape. Growing up to 30-60 ft in cultivation, this palm features enormous, nearly rounded leaves that can be more than 10 ft wide, with stiff, once-folded segments that are split on the ends. The tree is named after the first chancellor of the German Empire, Otto von Bismarck, and its only species, Bismarckia nobilis, derives from the Latin word for 'noble.' Bismarckia is endemic to western and northern Madagascar, where it grows in open grassland and plains of the central highlands. Although tolerant of some drought, it thrives in areas with adequate rainfall and needs plenty of room in a landscape area due to its massive crowns. The Silver Bismarck Palm is easy to grow in the right environment, adaptable to a wide range of soils, and prefers good drainage, as it does not like root rot. It is planted in several areas of the United States, Indonesia, Australia and many other subtropical areas. With its silver-blue foliage, Bismarckia nobilis 'Silver' Bismarck Palm is an excellent choice for any tropical garden or park, adding an exotic touch to the landscape.