convert a small query from sql server to mysql

Job ID: 31497205

Budget: €8 – €30 EUR

hi everyone, I have a small query written in SQL SERVER that should be converted to MySql ..

the query will be launched on a table of 60 million rows so it must be optimized

Delete from xTable where Cliente in
(select F1.Cliente From
(SELECT N=COUNT(CLIENTE),
Cliente
FROM XTABLE
GROUP BY CLIENTE
) F1
Inner join xTable on xTable.CLIENTE=F1.Cliente
Where f1.n>1 )
and isnull(xTable.Telefono,0)=0