Can confirm @errol’s experience with When Ordered By not being respected when you run the search in a script Had to change a column to a formula in order to get around that Minimum {id} When Ordered By {price} -->

MIN({id}) KEEP (DENSE_RANK FIRST ORDER BY {price})

Yep... my workaround too! Was definitely a fun one to troubleshoot 😁