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 = '697408'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 30 days
Germination: sow 1/8" deep, mulch the seed bed, keep moist
Abies koreana is a beautiful evergreen tree that is native to South Korea. It is a slow-growing tree that can reach heights of up to 50 feet. The needles are short and flat, and they are glossy dark green above and silver beneath. The tree produces small, purple cones. Abies koreana is a hardy tree that can tolerate a wide range of climates. It is a popular ornamental tree that is often used in landscaping. It can also be used as a Christmas tree.
The Korean fir is an endangered species in its native range.
The tree is tolerant of a wide range of soil conditions, but it prefers moist, well-drained soil.
The Korean fir is a shade-tolerant tree, but it will grow best in full sun.
The tree is relatively pest- and disease-free.
The Korean fir can live for hundreds of years.