28/10/2025 21:39

select distinct(m.idAccount), a.name, a.smtpHost, a.smptPort as smtpPort, a.smptUser as smtpUser, a.smtpPwd from MailingSentReceiver as r inner join MailingSent as s on s.id=r.idSent inner join Mailing as m on m.id=s.idMailing inner join Account as a on a.idAccount=m.idAccount where r.status='0' and s.sentTime<='2025-10-28 15:39:56' order by r.registered desc