select * from (
SELECT * FROM gomme where offerta='si' and pub='si' ORDER BY RAND() LIMIT 10) as tab
order by prezzo asc


cosi non funziona order by rand()