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 = '699115'
group by i.id
Scarification: Soak in water, let stand in water for 12 hours.
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
In a Nutshell:
* The plant is used as an ointment to treat blindness in camels. The fruit of many members of this genus is a very rich source of vitamins and minerals, especially in vitamins A, C and E, flavanoids and other bio-active compounds. It is also a fairly good source of essential fatty acids, which is fairly unusual for a fruit. It is being investigated as a food that is capable of reducing the incidence of cancer and also as a means of halting or reversing the growth of cancers. more...
* Propagation Seed - sow early spring in a greenhouse. Germination is usually good and fairly quick. Prick out the seedlings into individual pots when they are large enough to handle and grow them on in the greenhouse for their first winter. Plant out in late spring or early summer. Pinch out the shoot tips of the young plants in order to encourage bushy growth. more...
* Plants are very drought tolerant and have an extensive root system. They can be planted to stabilize banks and sandy soils. more...
* Lycium ruthenicum (Chinese: pinyin: hei guo gou qi), commonly known as Russian Box Thorn is a species of flowering plant in the nightshade family which can be found in Central Asia, southern part of Russia, throughout Northwest China, and Pakistan. more...
* In India, it grows in Kashmir where it is used by native people to cure blindness in camels. In Central Asia and Northwest China the species grows on elevation of 400–3,000 metres (1,300–9,800 ft) in saline deserts, sands and roadsides. more...