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 = '186'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Alnus japonica, also known as East Asian alder, is a beautiful deciduous tree that can grow up to 72 feet tall at a fast rate. Native to northeastern Asia and Japan, it prefers temperate forests, stream-banks, swamps, and roadsides. This tree has narrow, acuminate, serrulate, ovate to elliptic dark green leaves, which turn light green underneath. It bears long, pendant, yellow-brown catkins in clusters during the spring months, with female catkins producing ellipsoidal fruiting cones. Alnus japonica can tolerate strong winds but not maritime exposure, and it requires moist or wet soil. It is hardy to zone 4, and it can grow in heavy clay and nutritionally poor soils. This tree can fix nitrogen and prefers medium (loamy) and heavy (clay) soils. It can grow in semi-shade or full sun, making it an excellent choice for landscaping.