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 = '1150'
group by i.id
Australia, Austria, Belgium, Bulgaria, Canada, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovak Republic, Slovenia, South Africa, Spain, Sweden, Switzerland, United Kingdom
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 3/8" deep, tamp the soil, mulch the seed bed
Introducing Prunus serrulata 'Spontanea', a majestic Japanese Flowering Cherry originating from Japan. It also goes by the common name hill cherry and Yamazakura. This unique species is one of 10 or 11 wild Prunus genus that naturally populates Japan. Standing proud at a notable 20-40 ft, with its broad-leaved, umbrella-shaped canopy, this spectacle of nature can take from 5 to 10 years to bloom, lending to its unique allure.
The bark ranges from dark brown to purplish-brown with oblong grains, older trees possessing rough cracks. The annual branches are light brown or grayish with large swollen skin. The flowering period of this species brings forth an enchanting display from late March to mid-April. Its flowers are sizeable, measuring 25-35 mm in diameter, adorning its branches with delicate white to pale pink petals.
Each leaf of the Prunus serrulata 'Spontanea' is oblong to ovate with sharp serrations lining the margins, growing 5 to 12 cm long. Upon maturation, the leaves develop a whitish underside, while showcasing two glandular points at the upper part of the petiole. They bloom in red hues during fall, then bear spherical purple-black fruits from May to June.
Despite taking time to grow, it carries unique characteristics such as variable hues of young leaves from reddish-purple and brown to yellow-green and green. With diverse flowering periods and tree shapes exist among such variation, which contributes to its wild charm.