Created
July 20, 2012 14:12
-
-
Save c1982/3150939 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT domains.name, hosting.fp_adm, accounts.password, clients.login, | |
clients.passwd, dom_level_usrs.passwd As DomainPass, domains.status As Status | |
FROM domains | |
LEFT JOIN hosting ON hosting.dom_id = domains.id | |
LEFT JOIN sys_users ON hosting.sys_user_id = sys_users.id | |
LEFT JOIN accounts ON accounts.id = sys_users.account_id | |
LEFT JOIN clients ON clients.id = domains.cl_id | |
LEFT JOIN dom_level_usrs ON dom_level_usrs.dom_id = domains.id |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment