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 = '700347'
group by i.id
Scarification: Soak in water, let stand in water for 12 hours.
Stratification: none required
Germination: Sow seed in moist peat moss and just cover the seeds with peat. Keep moist and in the light and provide good drainage.
Other: Seed needs warm temperatures after sowing to germinate (75 degrees F +)
Discover Carnegiea gigantea, also known as the Giant Saguaro Cactus. A defining symbol of the American Southwest, these tree-like cactus species can reach over 70 feet in height, making a dramatic impact on the sandy landscapes of Arizona, the Mexican State of Sonora, and regions of California. Notably, the Saguaro blossom is the state wildflower of Arizona. With a lifespan exceeding 150 years, these iconic cacti may grow their first side arm anywhere from 75-100 years old. Some, intriguingly, never grow any arms at all. A unique characteristic of the Saguaro is its ability to absorb and store significant amounts of rainwater, visually expanding in the process. This trait allows for survival during prolonged drought periods. Come the months of April through June, witness the emergence of their beautiful white flowers. Fruit ripens by June, revealing 2000 seeds encased in sweet, edible flesh, attracted by native birds and humans alike. The Giant Saguaro’s fascinating features and resilience make it a cherished symbol of the desert.