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 = '797'
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/4" deep, tamp the soil, mulch the seed bed
In a Nutshell:
* Japanese Larch (Larix kaempferi, Karamatsu in Japanese) is a species of larch native to Japan, in the mountains of Chubu and Kanto regions in central Honshu.
* Japanese larch is an important tree in forestry plantations, being grown throughout central and northern Japan (north to Hokkaid?), and also widely in northern Europe, particularly the British Isles.
* L. kaempferi is used for ornamental purposes in parks and gardens. It is also widely used as material for bonsai. more...
* A fast-growing tree, it can be used in shelterbelt plantings. more...
Bonsai Comments:
Larix kaempferi makes a beautiful bonsai due to its fast growth, attractive young foliage, brilliant fall color, hardy cold-climate tree and easy to shape. Hardy to zones 4-6 it will not require winter protection above 15°C. Native to Japan, this tree wid planted worldwide as a forestry tree because it is tough. Sow seed in early spring, protect from the summer heat and prune in late winter. Though native to Japan, Larix kaempferi is also widely planted in other parts of the world as a forestry tree due to its strength and vigor.