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 = '572'
group by i.id
Scarification: Soak in water, let stand in water for 12 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Looking for a striking tree that can add elegance to any landscape? Look no further than the Cryptomeria japonica, also known as Japanese Cedar or Sugi. With its tall, conical form and reddish-brown bark that peels in thin strips, this evergreen tree can reach up to 70 metres in height and 4 metres in trunk diameter. Its needle-like leaves are arranged spirally and emit a pleasant aroma, while its seed cones are globular and about 1-2 cm in diameter. Cryptomeria japonica is widely used in forestry plantations in Japan, China and the Azores, and is cultivated as an ornamental tree in temperate regions across the globe, including Europe, North America and eastern Himalayan areas in India and Nepal. Known for its strength, resistance to decay, and pleasant scent, its wood is used for creating a range of items, from constructions and furniture to utensils and paper. Sugi is even the national tree of Japan and commonly planted around temples and shrines, with some of these trees impressively standing for centuries.