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 = '1422'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: warm stratify for 120 days, cold stratify for 60 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Other: remove seed from fruit prior to treatments
In a Nutshell:
* The flowers are sweetly fragrant. Self-sterile, it needs cross-pollination with a different plant in the same species if seed and fruit are to be produced. more...
* Grown for its 1/3" exquisite fruit in shades of turquoise or lapis lazuli, unlike any other ornamental, a mature tree covered with bright berries in the sun is extraordinarilyy beautiful, may be wider than tall, and in habit, bark, and leaf is reminiscent of Rhamnus, plant several trees to encourage fruit set, problem free, easy to grow, fruits in September and October, loved by birds, native from Himalayas to China and Japan .
* Requires an acid soil and a sunny position. Succeeds in a sunny position in any well-drained fertile neutral to acid soil. more...
* The juice of the bark is applied externally to sprains and muscular swellings. more...
Physical Characteristics
 Symplocos paniculata is a deciduous Shrub growing to 4 m (13ft) by 4 m (13ft). It is hardy to zone 5. It is in flower from May to June, and the seeds ripen from Oct to December. The flowers are hermaphrodite (have both male and female organs)The plant is not self-fertile. The plant prefers light (sandy), medium (loamy) and heavy (clay) soils and requires well-drained soil.The plant prefers acid soils. and can grow in very acid soils. It cannot grow in the shade.It requires moist soil.