Mysql: Consulta aleatoria

select * from mitabla where es_actividad=0 order by rand() limit 0,10