sql query to find out ftp passwords

[M.MARAVELIASD]

Hello,

I'm trying to make a query to see the passwords of some ftp accounts (for client's reminder).

I'm using this query:

SELECT d.name, s.login, a.password
FROM domains d, sys_users s, accounts a, clients cl
WHERE a.id=s.account_id
AND cl.id=d.id
AND d.cl_id=cl.id
ORDER BY d.name, s.login;

the login and passwords are correct, but the same domain keeps appearing..

any help?

 

[HrachT]

Hi,
Here is query to find ftp password for "domain.tld":

select login,password from sys_users join accounts on (account_id=accounts.id) where login=(select login from clients where clients.id=(select cl_id from domains where displayName='domain.tld'));