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 = '889'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours|none required
Stratification: A 2 week cold stratification at 40F will give a better germination.
Germination: Surface sow, cover lightly with medium or vermiculite.
Other: Once the seedlings germinate, keep warm, in the sun, and allow soil surface to dry out between waterings.
Discover the unique and endangered Metasequoia glyptostroboides, also known as the dawn redwood. This fast-growing, deciduous conifer is the sole living species of the genus Metasequoia and is native to Lichuan county in China. Despite the threat of extinction due to deforestation in its natural habitat, it has been extensively planted worldwide for its ornamental value. With light green foliage that turns a beautiful orange-brown in the fall and attractive reddish bark, this tree can grow to at least 200 feet in height. It is even capable of thriving in standing water, making it perfect for stabilizing riverbanks and paddy field walls. Bring a piece of history and natural beauty to your garden with the easy-to-grow dawn redwood. Order yours today and be a part of preserving this fascinating living fossil species.