codice:select * from ( select @riga:=@riga+1 as riga,id,prova,elenco_campi from tabella, (select @riga:=0) as r where ciao = 'prova' order by id limit 3) as t where riga in (1,3)
codice:select * from ( select @riga:=@riga+1 as riga,id,prova,elenco_campi from tabella, (select @riga:=0) as r where ciao = 'prova' order by id limit 3) as t where riga in (1,3)