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 = '697821'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: cold stratify for 90 days
Germination: sow seed 1/4" deep, tamp the soil, mulch the seed bed
Discover the incredible benefits of Schisandra sphenanthera nan wu wei zi, also known as the Southern Magnolia Vine. This unique variant of schizandra berry possesses a different biochemical profile to its more commonly known counterpart, Schisandra chinensis. Used in traditional Chinese medicine for its various medicinal properties, this horticultural plant also produces delicious, edible fruit that is also used in wine and vinegar preparation. Additionally, the fruit provides natural ingredients for soap and lubricant manufacture. This versatile plant grows up to 5100 metres in forests and thickets throughout China, providing health benefits and flavor to those who enjoy its many uses. Choose Schisandra sphenanthera for a truly unique experience.