Retrieving Web Users and Passwords from Plesk

To get a list of uid's and passwords for web users run the following query:

SELECT su.login AS "Web User", a.password AS "Password"
FROM web_users AS wu
JOIN sys_users AS su ON wu.sys_user_id = su.id
JOIN accounts AS a ON su.account_id = a.id
JOIN domains AS d ON wu.dom_id = d.id
WHERE d.name="domain.tld"