Ordering same 9 results by RAND()

[dachshund]

Hi,

 

I'm having a bit of trouble. I want to order the same 9 results by RAND(). Currently I have them ordered by 'avg' (average views) and that's working fine, but when I add a sub query to make those 9 results scatter by random it's causing some trouble.

 

Code I currently have that works:

 
$sql = "SELECT *, views / HOUR(TIMEDIFF(NOW(), date)) as avg
    FROM content
    WHERE date BETWEEN CURDATE() - INTERVAL 30 DAY AND NOW() - INTERVAL 2 HOUR
    AND views > 600 
    AND live = '0'
    ORDER BY avg DESC
    LIMIT 9";
 

 

What I'm trying to achieve but isn't showing any results:

 

 

$sql = "SELECT * FROM (SELECT *, views / HOUR(TIMEDIFF(NOW(), date)) as avg
    FROM content
    WHERE date BETWEEN CURDATE() - INTERVAL 30 DAY AND NOW() - INTERVAL 2 HOUR
    AND views > 600 
    AND live = '0'
    ORDER BY avg DESC
    LIMIT 9) ORDER BY RAND()";
 

 

[Barand]

A table subquery needs to be given a table alias

SELECT * FROM (
     SELECT ...
     ) as top9
ORDER BY RAND()

[dachshund]

perfect, thanks