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 = '700241'
group by i.id
Germination: surface sow and keep moist, requires light for germination
Other: Seed needs warm temperatures after sowing to germinate (75 degrees F +)
Discover the rich history and cultural significance of Trichocereus peruvianus var. Huancabamba or the Huancabamba Peruvian Torch Cactus. Found high in the Andean mountain deserts of Peru and Ecuador, this cactus has been used by the monks of a pre-Inca culture known as Chavín in their ritualistic ceremonies to diagnose spiritual links to a patient's illness. Its active compound, mescaline, has been reported to be present in a concentration of 1.2% in the dried cactus, and it also contains varying phenethylamines and other substances in minimal proportions. Today, Curanderos or medicine men of northern Peru still use it for spiritual and medicinal purposes. A close relative of the San Pedro cactus, this cactus is not to be missed on your journey of self-exploration. Learn more about the Huancabamba Peruvian Torch Cactus on our website.