Extract list of email accounts from Plesk that have a mailbox and no redirect

Posted on by 
SELECT mail.mail_name, domains.name
FROM domains
LEFT JOIN mail ON domains.id = mail.dom_id
LEFT JOIN DomainServices ON domains.id = DomainServices.dom_id
WHERE mail.postbox =  'true'
AND mail.mail_group =  'false'
AND DomainServices.type =  'mail'
AND DomainServices.status =  '0'

Comments are closed.