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 = '1380'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 60 days
Germination: surface sow and keep moist, tamp the soil, can be sown outdoors in the fall for spring germination
In a Nutshell:
* It is a shrub reaching 1 to 1.5 m . It bears compound, alternate, toothed leaflets which resemble ferns or sumac . Flowers are white and showy clustered at the end of branches. It's Chinese name is zhen zhu mei. more...
* Grown for its big fluffy creamy-white masses of flowers atop upright stems, rather coarse, and suckers to quickly form colonies, so perhaps for the wild garden or for covering banks, likes moist sites, will grow and flower in dry sites, but will be smaller in all its parts, compound leaves, native to northern Asia. more...
* The flowers are generous with their sweet perfume whatever the weather. They hold their fragrance for a considerable time. more...
[ edit ] Description It is a shrub reaching 1 to 1.5 m. It bears compound, alternate, toothed leaflets which resemble ferns or sumac . [ 2 ] Flowers are white and showy clustered at the end of branches.It's Chinese name is zhen zhu mei.
Â Sorbaria sorbifolia is a deciduous Shrub growing to 1.8 m (6ft) by 3 m (9ft). It is hardy to zone 2. It is in flower from Jul to August, and the seeds ripen in September. The flowers are hermaphrodite (have both male and female organs) and are pollinated by Insects. The plant prefers light (sandy), medium (loamy) and heavy (clay) soils.The plant prefers acid, neutral and basic (alkaline) soils..It can grow in semi-shade (light woodland) or no shade.It requires moist soil.It can tolerate atmospheric pollution.