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 = '700290'
group by i.id
Scarification: Soak in hot tap water, let stand in water for 2 days.
Stratification: none required
Germination: sow seed 1/8" deep, tamp the soil, mulch the seed bed
Other: Germination may be irregular and some seed may lie over 2 years before germination.
Capture the charm of the desert with Opuntia humifusa, commonly known as Devil's-tongue, Eastern Prickly Pear, or Indian Fig. This unique and resilient cactus flourishes in the hot, sunny areas of the eastern United States, northeastern Mexico and Mississippi. The distinct green stems of this perennial cactus are designed for surviving in these torrid conditions, featuring flattened segments covered in barbed bristles and occasionally, longer spines.
The fiery landscape comes alive in late spring when the Opuntia humifusa blooms vibrant yellow to gold flowers, sometimes highlighted with red centers. Measuring up to 2+ inches across, these waxy flowers line the edges of the mature segments on the cactus. As autumn approaches, the cactus bears juicy red or purple fruits, roughly 1 to 2 inches in size. These fruits hide a treasure of 6 to 33 light-colored seeds, transitioning from green to red as they mature, often remaining on the cactus till the next spring.
A truly versatile plant, besides adding a touch of the desert to your garden or home, the Opuntia humifusa has several practical uses. Its fruits are edible and can be processed into syrup or jelly, while the young cactus segments can be roasted, peeled and consumed similarly to string beans. This plant of many names, Devil's-tongue, Eastern Prickly Pear, or Indian Fig, provides an impressive visual spectacle and an interesting culinary experience, making it a unique addition for any cacti enthusiast.