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 = '693'
group by i.id
Scarification: Pour boiling water over seed , let stand in water for 12 hours; or small numbers of seed , file or sand through the outer seedcoat, let stand in water for 12 hours
Stratification: none required
Germination: sow seed 3/4" deep, tamp the soil, mulch the seed bed
Other: if boiling water treatment does not allow seed to imbibe, sulfuric acid treatment is required
Chinese medicine. Gleditsia sinensis has been used in China for over 2000 years as a detergent and for medicinal purposes. The thorns of Gleditsia sinensis are used as a medicinal herb in China and Korea and may have antitumor properties. They have been traditionally used for the treatment of inflammatory diseases, such as swelling, suppuration, carbuncle, and skin diseases.
Scientific studies have shown that Gleditsia sinensis exhibits in vitro effects that may indicate antiallergic activities, possibly due to the saponins found in its fruits. Studies in mice suggest that Gleditsia sinensis extract could be an effective therapeutic agent for the treatment of allergic asthma. The thorns also show antibacterial activity against certain Gram-positive and Gram-negative bacteria. Additionally, a lupane acid extracted from the thorns has shown in vitro anti-HIV activity. The fruit extract of Gleditsia sinensis has inhibitory effects on isolated cancer cell cultures.
The pod of Gleditsia sinensis is used as a soap substitute. The plant is a deciduous tree that can grow up to 12 meters in height. It is hardy and can tolerate drought and atmospheric pollution. The seed of Gleditsia sinensis is edible and can be roasted, dehusked, soaked, boiled, and eaten with sugar. The young leaves can also be cooked and eaten.
In conclusion, Gleditsia sinensis, also known as Chinese Honeylocust, Soap Bean, or Soap Pod, is a versatile plant with a long history of use in traditional Chinese medicine for various purposes. Its medicinal properties, including potential antitumor and antiallergic activities, antibacterial and anti-HIV properties, make it a valuable plant for further scientific study. Additionally, its use as a soap substitute and as an edible plant adds to its practicality and versatility.