We needed this for a migration of a plesk server, gl with them :)

Querys u run on the PSA db.
To export emailadress + passwords:
SELECT accounts.id, mail.mail_name, accounts.password, domains.name FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id
To export emailadress + plesk accounts.
SELECT name,cname,pname,email FROM `domains` LEFT JOIN clients ON domains.cl_id=clients.id

Gr gr
Thomas