Retrieving Plesk FTP Users Names and Passwords for Specific Domain

The following query will retrieve the sub-domain name, ftp username, and ftp password for a specific domain.

SELECT CONCAT(CONCAT(, '.'), AS subdomain, u.login, a.password FROM subdomains AS s
JOIN domains AS d ON
JOIN sys_users AS u ON
JOIN accounts AS a ON

If you want to see all subdomains, then omit the WHERE clause.