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 = '578'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow seed 1/16" deep , tamp the soil, keep moist
The Cunninghamia lanceolata, commonly known as Chinese Fir or Common China Fir, is a stunning evergreen coniferous tree from the Cupressaceae family. Native to China, Taiwan, and northern Vietnam, it can reach a height of 50-55m. Its conical shape and tiered, horizontal branches that are somewhat pendulous towards the tips make it a beautiful addition to any park or large garden. Its brown bark peels off in strips to reveal reddish underbark, and the green or blue-green needle-like leaves spiral around the stem with an upward arch. This tree is prized for its soft, highly durable, scented wood that is used to construct buildings, bridges, ships, and even coffins and in temple building where the scent is valued. Its wood is resistant to rot, easily worked, and not eaten by termites. This ornamental tree prefers moist and acid soil and thrives in full sun. With its beauty and useful wood, the Cunninghamia lanceolata is a versatile and valuable addition to any landscape.