Hi Peter,
Thanks for the suggestion, suggestion 3 works perfectly if I also switch
the order of the numbering as you suggest, because then I can do order by
priority desc, rand(), which returns the numbers first and then the 0's,
which is what I really wanted. Also, good point about adding high
Your options, as I see them, with 3 being the best I could come up with:
1. Make two queries. Depending on how many rows returned, this may be
the less taxing option processor wise.
2. Make the random query. As you iterate through them push folks with
priority 0 on one stac
