codice:
select * from (
select * from tabella order by rand() limit 100) 
as tab order by citta