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 = '5174'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow 1-2" deep, tamp the soil, mulch the seed bed
Castanopsis cuspidata, also known as Japanese Chinquapin or Japanese Shii, is a medium-sized evergreen tree that can grow up to 20-30m tall. It is related to beech and oak and is native to southern Japan and southern Korea. The leathery leaves are 5-9cm long and 2-4cm broad, and it grows in woods and ravines, especially near the sea. The cotyledon of the nut is a popular food that is boiled or roasted. This tree prefers a good deep medium to stiff loam in a sheltered position in semi-shade and a lime-free soil. Its dead wood is a host to many mushroom types, including the Shiitake. This tree is hardy to zone 7 and can grow in semi-shade in acid and neutral soils. It requires moist soil and is pollinated by winds and midges. If you're looking for an evergreen tree to grow in your garden, consider the Castanopsis cuspidata.