TranscendLinux.com

select concat(mail_name,'@', domains.name) as `e-mail`, password from domains
left join mail on domains.id=mail.dom_id
left join accounts on mail.account_id = accounts.id where postbox='true';