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 = '697835'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 48 hours
Stratification: cold stratify for 90 days
Germination: sow seed 3/4" deep, tamp the soil, mulch the seed bed
Other: may also require warm stratification, so germination may be delayed by 1 year.
Introducing the Ziziphus jujuba var. spinosa, also known as the Asian Date, Sour Jujube, or Wild Jujube. This small tree or large shrub, native to southern and eastern Asia, is widely used in Chinese medicine to strengthen liver function and increase immune-system resistance. The delicious fruit not only aids weight gain, improves muscular strength, and increases stamina but also has medicinal benefits. It is used as an antidote, expectorant, sedative, stomachic, and tonic to treat a range of conditions such as anaemia, pharyngitis, insomnia, and nervous exhaustion. The leaves are an effective remedy for promoting hair growth and forming a plaster in the treatment of strangury. However, the spinosa variety may be more thorny than the Ziziphus jujuba. Try this exotic and beneficial Asian Date for a great addition to your diet and health.