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 = '1531'
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 1" deep, tamp the soil, mulch the seed bed
Other: may also require warm stratification, so germination may be delayed by 1 year.
Ziziphus jujuba is hardier than most fruit trees, able to withstand extreme weather conditions and tolerant of poor soil. The jujube tree is typically 15 to 35 feet tall, with a rounded or vase-shaped crown. The branches are thorny, and the leaves are small and oval-shaped. The tree produces delicate yellow flowers that bloom in the spring, followed by its sweet and nutritious fruit in the fall. Known by many names, including Chinese Date, Jujube, and Tsao, this fruit has long been used in traditional medicine to treat various ailments. Its ability to aid in weight gain, improve muscular strength, and increase stamina has made it a sought-after ingredient in modern dietary supplements. In addition, jujube has been shown to strengthen liver function and increase immune-system resistance. The leaves of the plant are believed to promote hair growth, and it is also widely used in China as a treatment for burns. Whether eaten fresh or dried, this fruit is both delicious and beneficial for overall health and well-being.