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 = '1522'
group by i.id
Scarification: Soak in water, let stand in water for 24 hours
Stratification: none required
Germination: sow seed 1/4" deep, tamp the soil
Introducing the Soapweed Yucca, also known as Yucca glauca, narrowleaf yucca, plains yucca, or beargrass. This evergreen plant is native to North America, from Alberta and Saskatchewan in Canada, through the Great Plains to Texas, New Mexico, and Arizona in the United States. The Soapweed Yucca is widely grown as an ornamental plant in gardens, but it also bears edible parts such as fruits, seeds, flowers, and even flowering stems and roots, although the use of these is limited. In addition, dried yucca has the lowest ignition temperature of any wood, making it desirable for fire-starting. This plant has adapted to an extensive range of climatic and ecological conditions, from rocky deserts and badlands to mountainous regions, prairies and grassland, light woodland, coastal sands, and even sub-tropical and semi-temperate zones. The Soapweed Yucca is a truly versatile and resilient plant, making it both a practical and beautiful addition to any garden. Learn more about this fascinating species at plants.usda.gov.