为什么MySQL Rand（）讨厌我？

Here is a simplified query of something I am trying to do on a larger join query. It is still breaking on this small scale. I am trying to generate a random number for each row pulled back in the range of 1-60. I then want to order the returned rows by this random number.Here is a simplified query of something I am tr