$sql="SELECT *FROM (SELECT * FROM icerik ORDER BY icerik_no DESC LIMIT 0,10) ORDER BY RAND()";
bunu denediniz mi ?
sadece 1 tane basmak istiyorsanız da bunu yapın
$sql="SELECT *FROM (SELECT * FROM icerik ORDER BY icerik_no DESC LIMIT 0,10) ORDER BY RAND() LIMIT 1";