Oridinare record per campo.. ma random..

[henry78]

Originariamente inviato da nicola75ss

select * from (
select * from tabella order by rating desc limit 5) as tab
order by rand()

ho provato così ma non vengono comunque ordinati per il campo rating


$query2 = "select * from (SELECT * FROM tab_uno WHERE (data <= '$data') AND (rating >= 1) GROUP BY id ORDER BY rating DESC LIMIT 30) as tab order by rand()";

c'e' qualcosa di sbagliato?