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 = '1387'
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/16" deep, tamp the soil, lightly mulch the seed bed.
Sorbus commixta, also known as Japanese Rowan, is a beautiful species of deciduous tree native to Japan, Sakhalin, and the Korean island of Ulleungdo. This tree produces white flowers clustered to 3" across in May, followed by bright orangey-red fruits about 1/3" across in late summer. Its dark green leaves turn purple and red in fall, providing stunning colors. This tree is suitable for street planting and grows up to 7-10 meters, rarely up to 18 meters tall. It prefers moist, well-drained soil and full sun and is hardy in zones 5-9. Sorbus commixta is also grown as an ornamental tree outside its native range in Europe and North America, and various cultivars have been selected. Its wood is known for being sturdy in firewood, as it does not get entirely consumed by the fire even after repeated use. Consider adding Sorbus commixta to your garden or street for its beauty and sturdiness.