To find details about protected directories in Plesk.

protected_directories_in_plesk.sql

SELECT domains.name, protected_dirs.path, protected_dirs.realm, pd_users.login, SUBSTRING(accounts.password, 1), `protected_dirs`.`ssl`, protected_dirs.non_ssl
FROM protected_dirs, pd_users, domains, accounts
WHERE domains.name LIKE '%<domain.dom>%'
AND protected_dirs.dom_id = domains.id
AND pd_users.pd_id = protected_dirs.id
AND pd_users.account_id = accounts.id;