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 = '5036'
group by i.id
Germination: Surface sow and just cover with vermiculite. Sow in temperatures of 70-75F (20-25C). Do not exclude light.
Other: Germination is slow and could take 1 - 6 months at 15°c.
The Metrosideros excelsa, also known as the pōhutukawa or New Zealand Christmas tree, is a coastal evergreen tree in the Myrtaceae family known for its vibrant red flowers made up of a mass of stamens. Renowned for its strength and beauty, the pohutukawa is regarded as a chiefly tree by Māori. It grows up to 25 metres high and has a spreading, dome-like form. Vigorous and easy to grow, it has naturalised in several areas in New Zealand and other mild-to-warm climates around the world. Its wood is dense, strong, and highly figured, and was used for beaters and other small, heavy items and shipbuilding. The pohutukawa is under threat from browsing by the introduced common brushtail possum, and conservation efforts aim to reverse the decline of pohutukawa and other Metrosideros species. Many cultivars have been released, with varying flower colors and growth habits. Add a touch of strength and beauty to your holiday decor with a Metrosideros excelsa Christmas tree.