28/12/2025 05:01

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-12-27 23:01:25' order by r.registered desc